Can't connect to MySQL server on 'localhost' (10061)

Mysql Problem Overview

I recently installed MySQL 5 on Windows 2003 and tried configuring an instance. Everything worked fine until I got to "Applying Security settings", at which point it gave me the above error (Can't connect to MySQL server on 'localhost' (10061)).

I do have a port 3306 exception in my firewall for 'MySQL Server'.

Mysql Solutions

Solution 1 - Mysql

Got this error on Windows because my mysqld.exe wasn't running.

Ran "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" --install from the command line to add it to my services, ran services.msc (start -> run), found the MySQL service and started it.

Didn't have to worry about it from there on out.

Solution 2 - Mysql

To resolve this problem:

go to the task manager
select Services tab
find MySql service
Running

That's all.

Solution 3 - Mysql

You'll probably have to grant 'localhost' privileges to on the table to the user. See the 'GRANT' syntax documentation. Here's an example (from some C source).

> "GRANT ALL PRIVILEGES ON %s.* TO '%s'@'localhost' IDENTIFIED BY '%s'";

That's the most common access problem with MySQL.

Other than that, you might check that the user you have defined to create your instance has full privileges, else the user cannot grant privileges.

Also, make sure the mysql service is started.

Make sure you don't have a third party firewall or Internet security service turned on.

Beyond that, there's several pages of the MySQL forum devoted to this: http://forums.mysql.com/read.php?11,9293,9609#msg-9609

Try reading that.

Solution 4 - Mysql

I had difficulty accessing MySQL while connecting via a localhost connection on the standard port 3306, which worked fine when I installed and configured it for prior classes I had taken in MySQL and Java. I was getting errors like "error 2003" and "Cannot connect to MySql server on localhost (10061)". I tried connecting from both MySQL Workbench (5.2.35 CE) and Netbeans (7.2). I am using Windows 7 64 bit professional.

I tried typing in services.msc in the start menu search box, which opened the services dialog box to show all the services installed in windows. I scrolled down to MySQL and started this service. Subsequent attempts to connect to MySQL from MySQL WorkBench and from the command prompt succeeded.

Solution 5 - Mysql

English:

press Windows + R
write "services.msc". Then press Enter
search for MySQL57 and right click
click on start the service

Français :

Appuyez sur la touche Windows + R
Écrire "services.msc" Puis appuyez sur Entrée
Recherchez MySQL57 et clic droit
Cliquez sur rédémarrer

Solution 6 - Mysql

Make sure that your windows host file (located at c://windows/system32/drivers/etc.host) has following line. If not, add it at the end
```
127.0.0.1 localhost
::1 localhost
```
Sometimes mysql can not trigger Windows to force start host services if firewall blocks it, so start it manually

win+run>>services.msc, select the "MySQL_xx" where "xx" is the name you have assigned to MySQL host services during setup. Click on 'start' to start from hyperlink appeared on left side.

Solution 7 - Mysql

press Windows key + R write "services.msc" enter search for "MYSQL56" write click on it and start the service

Solution 8 - Mysql

I tried Kuzhichamadam Inn's solution and found that a slight change needed to be made.

MYSQL57 was a network service. I had tried this repeatedly with no success. When I opened services.msc I found another service for localhost: MySQL. I started that one using the process below and it worked.

run > services.msc > rightclick MySQL > properties >start

Solution 9 - Mysql

I got this error when I ran out of space on my drive.

Solution 10 - Mysql

Go to Run type services.msc. Check whether or not MySQL services are running. If not, start it manually. Once it is started, type MySQL Show to test the service.

Solution 11 - Mysql

To connect locally to MySql, you do not have to setup a firewall with inbound rules. But, even if you already setup iptables to allow the TCP inbound port 3306 and grant the privilege to the user to access the db locally, you may have to setup the bind address in your my.cnf file, edit the default address there and put the server IP address that is running the MySql service.

Solution 12 - Mysql

Since I have struggled and found a slightly different answer here it is:

I recently switched the local (intranet) server at my new workplace. Installed a LAMP; Debian, Apache, MySql, PHP. The users at work connect the server by using the hostname, lets call it "intaserv". I set up everything, got it working but could not connect my MySql remotely whatever I did.

I found my answer after endless tries though. You can only have one bind-address and it cannot be hostname, in my case "intranet".

It has to be an IP-address in eg. "bind-address=192.168.0.50".

Solution 13 - Mysql

run > services.msc > rightclick MySQL57 > properties >set start type option to automatic

after restarting computer

At cmd

cd: C:\

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

it will become

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

type mysql -u root -p

ie C:\Program Files\MySQL\MySQL Server 5.7\bin> mysql -u root -p

Enter password: ****

That's all

It will result in

mysql>

Solution 14 - Mysql

Another possibility:

There are two ways the MySQL client can connect to the server: over TCP/IP, or using sockets. It's possible you have your MySQL server configured to support socket connections, but not network connections.

Solution 15 - Mysql

Nothing to do just "Reset to Default" your firewall setting it will start working.

I read many solutions but nothing worked properly, so at last I reset firewall settings which worked.

Solution 16 - Mysql

finally solved this.. try running mysql in xammp. The check box of mysql in xammp should be unclicked. then start it. after that you can open now mysql and it will now connect to the localhost

Solution 17 - Mysql

Edit your 'my-default.ini' file (by default it comes with commented properties)as below ie.

basedir=D:/D_Drive/mysql-5.6.20-win32
datadir=D:/D_Drive/mysql-5.6.20-win32/data
port=8888

There is very good article present that dictates commands to create user, browse tables etc ie.

http://www.ntu.edu.sg/home/ehchua/programming/sql/MySQL_HowTo.html#zz-3.1</br>

Solution 18 - Mysql

I did not have Mysql server installed, that package was missing and I got it from this link https://dev.mysql.com/downloads/installer/

Solution 19 - Mysql

Right click on My Computer
Click on Manage
Go to Services and Application
Select Services and find MySQL service
Right click on MySQL and select Start

Content Type	Original Author	Original Content on Stackoverflow
Question	Cameron A. Ellis	View Question on Stackoverflow
Solution 1 - Mysql	ryanjones	View Answer on Stackoverflow
Solution 2 - Mysql	JapoDeveloper	View Answer on Stackoverflow
Solution 3 - Mysql	Chris	View Answer on Stackoverflow
Solution 4 - Mysql	Colin	View Answer on Stackoverflow
Solution 5 - Mysql	Sofia	View Answer on Stackoverflow
Solution 6 - Mysql	Uday Hiwarale	View Answer on Stackoverflow
Solution 7 - Mysql	Mujtaba Zaidi	View Answer on Stackoverflow
Solution 8 - Mysql	Ted WIlcox	View Answer on Stackoverflow
Solution 9 - Mysql	MDave	View Answer on Stackoverflow
Solution 10 - Mysql	Muhammad Abbas	View Answer on Stackoverflow
Solution 11 - Mysql	user2690551	View Answer on Stackoverflow
Solution 12 - Mysql	iknownothing	View Answer on Stackoverflow
Solution 13 - Mysql	Kuzhichamadam Inn	View Answer on Stackoverflow
Solution 14 - Mysql	dj_segfault	View Answer on Stackoverflow
Solution 15 - Mysql	Tarun	View Answer on Stackoverflow
Solution 16 - Mysql	user3103628	View Answer on Stackoverflow
Solution 17 - Mysql	hmehandi	View Answer on Stackoverflow
Solution 18 - Mysql	lord	View Answer on Stackoverflow
Solution 19 - Mysql	Mukunda Jois	View Answer on Stackoverflow