[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 130
  • Last Modified:

PhPMyAdmin

I have phpmyadmin installed on my server.  However, it won't connect to the MySQL Server.  It is a virtual machine on the cloud running windows 2008 Server.  How do I make sure the the MySQL Server is on and running?  If it is not on, how do I turn it on?
0
rgranlund
Asked:
rgranlund
  • 4
  • 3
1 Solution
 
SimonCommented:
See http://dev.mysql.com/doc/mysql-windows-excerpt/5.1/en/windows-testing.html
and http://dev.mysql.com/doc/refman/5.1/en/connecting.html in the MySQL documentation for Windows. The first of those links shows how to check that MySQL is running.

phpmyadmin also needs to be configured to connect to MySQL.

First check if you can connect to MySQL from the command line:
Something like (the path may be different for you):
C:\MYSQL\Bin>mysql -u root -p

You should get a password prompt.
0
 
rgranlundAuthor Commented:
When I type in C:\MYSQL\Bin>mysql -u root -p at the command line it says access denied
0
 
SimonCommented:
OK, that means that user root doesn't exist in the grants table... but that mysql IS running.

If I issue that command with a non-existent user I get this error msg:
"ERROR 1045 (28000): Access denied for user 'odbc'@'localhost' (using password: YES)"

I don't know how your MySQL was set up. You may have
mysql
or
odbc
as the username

Try those or look for documentation from the person who initially installed mysql.

Failing that I can probably point you to some links to reset the permissions.
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
rgranlundAuthor Commented:
When I type in "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqlshow"
I get Can't connect tp MySQL Server on 'localhost' <10061>

Does that mean anything?
0
 
SimonCommented:
Is this a new install of MySQL?
If so, try
C:\MYSQL\Bin>mysql -u root
(without the -p)

MySQL initially installs with no security so that may work.

Apologies, but I don't think I'll be able to help you further on this. I'm running it on OS X. If it wasn't you that installed MySQL, I can only suggest that you refer to the person/team that installed it and ask for help, though another expert may be able to provide better assistance.
0
 
rgranlundAuthor Commented:
Thanks Simon, I'm on the correct path now!
0
 
SimonCommented:
Good to hear that!
0
 
Dave BaldwinFixer of ProblemsCommented:
If MySQL is running, you will see either 'mysqld.exe' or 'mysqld-nt.exe' listed in Task Manager under Processes.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now