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.
For example an output like below ensures that the process 932 is listening on port 3306:
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).