Ошибка подключения mysql 10061

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’.

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.

answered Jul 1, 2016 at 15:02

answered Aug 24, 2017 at 6:12

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.

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».

answered Jan 28, 2016 at 8:34

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

after restarting computer

At cmd

cd: C:

C :> cd "C:Program FilesMySQLMySQL Server 5.7bin"

it will become

C:Program FilesMySQLMySQL Server 5.7bin>

type mysql -u root -p

ie C:Program FilesMySQLMySQL Server 5.7bin> mysql -u root -p

Enter password: ****

That’s all

It will result in

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

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

1. Right click on My Computer
2. Click on Manage
3. Go to Services and Application
4. Select Services and find MySQL service
5. Right click on MySQL and select Start

answered Aug 11, 2016 at 7:28

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’.

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.

answered Jul 1, 2016 at 15:02

answered Aug 24, 2017 at 6:12

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.

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».

answered Jan 28, 2016 at 8:34

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

after restarting computer

At cmd

cd: C:

C :> cd "C:Program FilesMySQLMySQL Server 5.7bin"

it will become

C:Program FilesMySQLMySQL Server 5.7bin>

type mysql -u root -p

ie C:Program FilesMySQLMySQL Server 5.7bin> mysql -u root -p

Enter password: ****

That’s all

It will result in

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

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

1. Right click on My Computer
2. Click on Manage
3. Go to Services and Application
4. Select Services and find MySQL service
5. Right click on MySQL and select Start

answered Aug 11, 2016 at 7:28

asked Dec 22, 2008 at 1:12

from the commandline (start/run/ type cmd, press ok), type:

telnet localhost 3306

If MySQL is running, you’ll see the mysql version (and some garbage).

To see if the service is running, type:

sc query mysql

You’ll see something like this if it’s running:

SERVICE_NAME: mysql
        TYPE               : 10  WIN32_OWN_PROCESS
        STATE              : 4  RUNNING
                                (STOPPABLE,PAUSABLE,ACCEPTS_SHUTDOWN)
        WIN32_EXIT_CODE    : 0  (0x0)
        SERVICE_EXIT_CODE  : 0  (0x0)
        CHECKPOINT         : 0x0
        WAIT_HINT          : 0x0

answered Dec 22, 2008 at 3:07

To check to see if MySQL is running, provided its installed as a service you can go to Start -> Control Panel -> Administrative Tools -> Services (i may be a bit off on those paths, I’m an OS X / Linux user), and look for MySQL on that list. See if it is started or stopped.

You can then do a portscan if you really want to and determine if that port is open. There are all kinds of free tools online that will scan your IP and tell you which ports are open and what is listening on them.

answered Dec 22, 2008 at 2:56

Unless you did something during the install, I believe that the port will be standard and the service will NOT be running after install.

MySQL provides several GUI tools for managing servers: http://dev.mysql.com/downloads/gui-tools/5.0.html One of those tools is the «MySQL System Tray Monitor» which will detect the running service, and allow you to stop and start the server easily. You can also review the list of services for «MySQL» to see if that service is active.

If the service is running and you still can’t connect, you need to make sure the Windows firewall is not blocking access to the port. If your firewall is not configured to notify you when it block a program (check the Windows Firewall control panel, it might not have notified you that it’s detected the program).

answered Dec 22, 2008 at 3:05

Make sure it is running, check in my.cnf that it is really listening to the correct IP ( 127.0.0.1 ) and make sure you connect to the correct port aswell.

Try using telnet for debugging aswell and see where the problem lies, maybe mysql isnt started, or listens to a different port.

answered Dec 22, 2008 at 1:14

try to change a mysql port 3300 to «3306»