NuSphere Forums Forum Index
NuSphere Forums
Reply to topic
FAQ: I can't connect to MySQL (error 10061)
Site Admin

Joined: 13 Jul 2003
Posts: 8351
Reply with quote
I can't connect to MySQL (error 10061)

Quote:
Whenever I try to connect to database I get Cant conect to MYSQL server on localhost(10061).


Error 10061 means that no service is running on the port you selected for in mySQL settings OR mySQL server is NOT running.

1. Make sure mysql service is running
2. Make sure mysql is running on TCP/3306 port and this port is selected for the account.

The following command will show you all listening sockets (and daemons PIDs) running on your computer.
Code:
netstat -naop TCP


For example an output like below ensures that the process 932 is listening on port 3306:

Code:
  Proto  Local Address          Foreign Address        State           PID
  TCP    0.0.0.0:135            0.0.0.0:0              LISTENING       1560
  TCP    0.0.0.0:445            0.0.0.0:0              LISTENING       4
  TCP    0.0.0.0:1025           0.0.0.0:0              LISTENING       1768
  TCP    0.0.0.0:1031           0.0.0.0:0              LISTENING       4
  TCP    0.0.0.0:3306           0.0.0.0:0              LISTENING       932
               ^^^^^^^^^^


Then open Task Manager, enable PID column and see what process name corresponds to the PID (932 in my example).
View user's profileFind all posts by dmitriSend private messageVisit poster's website
FAQ: I can't connect to MySQL (error 10061)
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 5 Hours  
Page 1 of 1  

  
  
 Reply to topic