Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

mysql

I installed MySQL on Microsoft Windows 8 Using a noinstall Zip Archive. But when I tested by executing the following commands on windows prompt, the above error showed up.

C:\> "C:\MySQL\bin\mysqlshow"   C:\> "C:\MySQL\bin\mysql" test 
like image 589
Foreever Avatar asked Jul 02 '13 12:07

Foreever


People also ask

Can't connect to MySQL server on server 10061?

The error (2003) Can't connect to MySQL server on ' server ' (10061) indicates that the network connection has been refused. You should check that there is a MySQL server running, that it has network connections enabled, and that the network port you specified is the one configured on the server.

Can't connect to local MySQL server on localhost?

normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket file name or TCP/IP port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service.

Can't connect to MySQL server on localhost 3306 10061 No connection could be made because the target machine actively refused it?

The error above means that your request to connect to the MySQL server has been refused. There are two things you need to check to fix this error: Make sure that your MySQL service is actually running. Check that you are attempting to connect to the right port number.


1 Answers

You don't need to restart your windows. The easiest way to achieve this is

  1. Go to <Extracted folder location>/bin/
  2. Run mysqld (service)
  3. close the cmd prompt
  4. Run mysql.exe or the better way to do is add the location to PATH environment Variable
like image 143
debiansse Avatar answered Sep 28 '22 19:09

debiansse