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

error 2003 (hy000): can't connect to mysql server on (110)
error 2003 (hy000): can't connect to mysql server on '127.0.0.1' (10061)
can't connect to mysql server on (115)
error 2003 (hy000 can t connect to mysql server on '192.168 13 111)
error 2003 (hy000 can t connect to mysql server on 110 connection timed out)
error 2003 (hy000 can t connect to remote mysql server for client connected to 0.0 0.0 6446)
error 2003 hy000 can t connect to mysql server on 192.168 56.101 111
mysql cmd error 2003

I'm following Vogella's tutorial on MySQL and I'm hitting a brick wall when I try to imitate the example. I've installed MySQL, and as he instructs I run it from the command line. When I do so, I get this error:

C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.9>mysql -u root -p
Enter password: ******
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.9>

Does anyone know why?

The solution is very simple. The problem is the mysql service is not started. So we first need to start the mysql service before 'mysql -u user_name -p' command. To do that, navigate to 'bin' folder of mysql in command prompt. E.g:

C:\Program Files\MySQL\MySQL Server 5.7\bin>

In your case probably,

C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.9\bin>

or

C:\Program Files (x86)\MySQL\bin>

or

If you have XAMPP installed, then to start mysql associated with it, navigate to

C:\xampp\mysql\bin>

then type the command mysqld -u root -p

It will output:

'2017-04-04 13:40:27 8536 [Note] mysqld (mysqld 10.1.21-MariaDB) starting as process 5640 ...'

This shows mysql is started.

Now type your command mysql -u root -p, it will work for sure.

Fix: ERROR 2003 (HY000): Can't connect to MySQL server on , Fix: ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111). by Aaron Kili | Published: December 23, 2016 | Last Updated: December 23,  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.

try restarting the MYSQL app in the XAMPP control panel. It worked for me. Good luck!

MySQLで「ERROR 2003 (HY000): Can't connect to MySQL server」と , If you are using ubuntu , you have to use the following steps to avoid this error(if there is no replication enabled):. run the command vim  The mysql run well. But after a specific period of time, i'm getting ERROR “ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10055)”. When i reboot the machine, the problem gets solved.

Go to Start->Run and type services.msc. That's how you get to windows services window. Look for MySQL Server, Right Click, Start Service.

You could also get to Windows Services Window by Start -> Control Panel -> Administrative Tools -> Services

If there's no such service MySQL Server, then install MySQL Server from here https://dev.mysql.com/downloads/mysql/

ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1 , ERROR 2003 (HY000): Can't connect to MySQL server on 'XXX.XX.XX.XX' (110). Posted October 28, 2017 119.3k views. UbuntuMySQLApacheFirewall. MySQL 5.7.17; MySQL Workbench 6.3; In MySQL Workbench I can connect to my local instance, create a new database and edit this database. But, if i try to import an sql file I am getting the following error: ERROR 2003 (HY000): Can't Connect to MySQL server on 'localhost' (110)

Open the Xampp control panel and start the mysql module. For wamp, do the same. This is the simplest ever solution I've got !

ERROR 2003 (HY000): Can't connect to MySQL server on 'XXX.XX , Symptom: The error message: ERROR 2003 (HY000): Can't connect to MySQL server on 'IP address' (111) Appears white an attempt to  mysql -h 1xx.xx.4.136 -u nickruiz -p ERROR 2003 (HY000): Can't connect to MySQL server on '1xx.xx.4.136' (111) Clearly there's something wrong that's preventing me from being able to use my global IP address. Notes: I've tried testing the remote connection on the same machine and also via SSH from a remote machine.

mysql --protocol=TCP -P3306 -u user -p

ERROR 2003 (HY000): Can't connect to MySQL , This error happened for me also. ERROR 2003 (HY000): Can't connect to MySQL server on 'po51' (111) Clearly this is a networking-level error  Try localhost instead of 127.0.0.1 to connect or in your connection-config. Worked for me on a Debian Squeeze Server. improve this answer. edited Dec 14 '12 at 20:18. 77 silver badges. 122 bronze badges. answered Dec 14 '12 at 19:59.

MySQL :: Re: Error 2003 (HY000): Can't , It appears you correctly commented out the bind-address directive in my.cnf . But this change needs to be made on the remote server in order to have any effect  The interactive transcript could not be loaded. Rating is available when the video has been rented. This feature is not available right now. Please try again later. Published on Sep 13, 2017. See

ERROR 2003 (HY000): Can't connect to MySQL , root@inkd00:/srv# mysql -u root -h x.x.x.x -P 3307 ERROR 2003 (HY000): Can't connect to MySQL server on 'x.x.x.x' (110) The client stuff should not have the mysql.sock file. Can anybody suggest me where to connect the sock file and mentioning sock file. I would very much appreiciate anyone help. Thanks in advance.

ERROR 2003 (HY000): Can't connect to MySQL server on localhost ,

Comments
  • Is the mysql-server started?
  • Whenever I try (i.e. when I enter mysql into the prompt) it gives me the same error
  • You are using the mysql client which will now try to connect to a mysql-server running on your machine. The error-message looks like there is no such server running.
  • Problem with the firewall perhaps?
  • How do I get a server running? The article doesn't mention it
  • Also, to get to the Run prompt, you could press Super (Windows logo key) + R
  • It's good to have additional comments along with your solution.