Unable to connect to MySQL server on localhost (10061) in window 7

Question

I have window 7 as the operating system on a production machine, where I am trying to use MySQL Server 5.0 as a database. But I can not configure MySQL on my production machine. Below is the error I am getting.

The security setting cannot be applied to the database because the connection ended with the following error:

Error No. 2003
Cannot connect to MySQL server on localhost (10061).

The message also indicates that you need to open TCP port 3306 to solve this problem, I checked it and found that TCP port 3306 is already open and the state is being monitored.

This is my netstat -an command result -

Proto LocalAddress ForeignAddress State
 TCP 0.0.0.0lla306 0.0.0.0:08 LISTEN

This means that TCP on 3306 is open. Can someone tell me a solution to this problem. However, I can install and configure the same MySQL Server setup in the xp window. I also tried google and found many blogs, but none of them are needed.

Many thanks.

Answer 1

Change

 host: localhost

to

 host: 127.0.0.1

This is probably due to how your database is being solved.

Answer 2

Have you checked if port 3036 is actually used by another application? Have you checked if telnet hostname3036 is running on the local MySQL server, as well as on the remote machine?

Answer 3

, MySQL . , " " > "" > " " > "" MySQL. .

, .

Answer 4

MySQL .
mysqld , . , , 3 , .

Answer 5

The problem was solved. MySQL was not running in the Services section of the Settings. Because XAMMP disabled an already running application in the background.