DEV Community

Cover image for MySQL Error 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061)
Data Stories
Data Stories

Posted on

MySQL Error 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061)

So we have finished installing MySQL and we want to start it at the command line. There are times you may come across the 2003(HYOOO) error or the MySQL Command Line Client may disappear after it prompts you for your password. Do not fret, this is easily fixed.

How to fix it;

Please see the steps below to fix the problem.

  1. Log in as Admin to your system
  2. Open the Task Manager panel
  3. Go to the Services tab.
  4. Look for your MySQL service. It will show the service has stopped.
  5. Select the MySQL and right click. You will get Start option. Select start command, give it a few minutes to start and in a while it will read running. Please see the below image for reference.
    Image showing how to start MySQL server from task manager

  6. Please recheck that MySQL service has been started successfully.

  7. In case MySQL services do not start using this way, It means you are not logged in with Admin account. In this case you will receive this error.

Image showing error because f not running ad admin

Please follow next given steps to start MySQL service from Administrative Panel.

  1. Please Go to Control Panel > All Control Panel Items > Administrative Tools.
  2. Go to Services.
  3. Select MySQL56 under Name column.
  4. Click on start link from left panel to start MySQL Service.
  5. Once MySQL service started go to the MySQL Command Line Client
  6. Enter your MySQL password.
  7. We can see image given below after MySQL server started successfully.

Login sucess

Login success! Your MySQL server is now ready to connect!

Thanks for reading this post. Please let me know if your problem has been resolved. Like, comment and share.

Finally, In case you want to learn how to install MySQL server from scratch please check this blog post on my learning SQL series.

Top comments (0)