Posted on 2015-01-17
Last Modified: 2015-01-24
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?
Question by:rgranlund
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 18

Accepted Solution

Simon earned 500 total points
ID: 40555665
and 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.

Author Comment

ID: 40555688
When I type in C:\MYSQL\Bin>mysql -u root -p at the command line it says access denied
LVL 18

Expert Comment

ID: 40555693
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
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.
Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.


Author Comment

ID: 40555695
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?
LVL 18

Expert Comment

ID: 40555701
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.

Author Comment

ID: 40555704
Thanks Simon, I'm on the correct path now!
LVL 18

Expert Comment

ID: 40555705
Good to hear that!
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40555833
If MySQL is running, you will see either 'mysqld.exe' or 'mysqld-nt.exe' listed in Task Manager under Processes.

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL 2014 missing dll from Bin? 3 31
SQL Server Express or Standard? 5 24
robocopy question 3 27
Sql server Error message 3 14
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

761 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question