Can t connect to mysql server on localhost (10061)

Home → MySQL

|In: MySQL|Last Updated: September 14, 2022

Table of Contents Show

Home → MySQL
Comments (25)
Can ́T connect to MySQL server on localhost 10060?
How do I access MySQL server on localhost?
Can not connect to MySQL server through socket?
Can't connect to MySQL specified instance?

I have installed MySQL version 5.6 on windows 7. My Installation was successful and without any error. I received “ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)” while I was trying to start MySQL server from command prompt. I am attaching the screenshot of the error I received.

Starting MySQL From Command Prompt

When I could not connect to MySQL server installed on my windows. I tried to connect MySQL Server directly by using “MySQL5.6 Command Line Client”. Same error was occurring and MySQL Command line was disappearing.

I was little worried of this error – ERROR 2003 (HY000). I did not get any of issues while installing MySQL5.6 on windows so MySQL server should work properly.
I did search on internet (MySQL forum, DB related forums) and I resolved Can’t connect to MySQL server on ‘localhost’ (10061) error. Now I was able to run MySQL server from command prompt.

Reason for ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061) – MySQL services has not been started.

Please see the steps below to fix this problem.

1. Please Log in as Admin to your System.
2. Open your Task Manager panel.
3. Go to Services tab.
4. See there for MySQL presence. It will look like this image given below.In my case it is displayed like MySQL56.

Showing MySQL Services Status using Task Manager

In the above image you can see that MySQL56 service is showing as Stopped. Please see the blue dark line in the image.

5. Please select MySQL56 and do right click. You will get Start option. Select Start command to start MySQL Services. Please see the below image for your 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.

Getting Error if not logged in as Admin

Please follow next given steps to start MySQL service from Administrative Panel.
8. Please Go to Control Panel > All Control Panel Items > Administrative Tools.
9. Please go to Services. Below image is showing the process.

Image showing Services in Administrative Tools

10. Please select MySQL56 under Name column.
11. Please click on start link from left panel to start MySQL Service. Please see the image below for your reference.

Starting MySQL server from Administrative panel

12. Once MySQL service started. Please go to MySQL bin directory using command prompt and retype the command >mysql -u root -p mysql
13. Please enter your MySQL password.
14. We can see image given below after MySQL server started successfully.

MySQL Server Started Successfully from Command prompt

Thanks for reading this post. Please let me know if your problem has been resolved.

Finally, In case you want to learn how to install MySQL server from scratch please check this YouTube video. Please do not forget to subscribe to our Youtube channel.

Comments (25)

Can ́T connect to MySQL server on localhost 10060?

The error 10060 is returned by the MySQL client when a connection could not be established with the service on the system you are connecting to. This is commonly caused by a firewall block or network issue preventing the connection.

How do I access MySQL server on localhost?

Connecting via a standard connection Enter 127.0. 0.1 for the host. The default username for a new MySQL installation is root, with a blank password. You can leave the port field blank unless your server uses a different port than 3306.

Can not connect to MySQL server through socket?

Another possible solution to the >can't connect to local mysql server through socket> error message is to try and connect to the MySQL using the 127.0. 0.1 ip address instead of localhost. When you use localhost to connect to MySQL, the operating system uses the socket connector.

Can't connect to MySQL specified instance?

simply means that connection is not possible for one of the following (or similar) reasons: There is no MySQL server running at the specified host. Connection to the MySQL server is not allowed using TCP-IP. Check the 'skip-networking' setting in the MySQL configuration file (my.