"Communicationslinkfailure..." error is reported when you remotely connect to the mysql database. _ MySQL

BitsCN.com

Today, when I used my‑hotoshop/target = _ blank class = infotextkey> pse to connect to mysql, the message "Communications link failure, Last packet sent to the server was 0 MS ago. "The error page is shown in:

Mydomainhotoshop/target = _ blank class = infotextkey> pse error prompt page

Check that the remote server can be pinged on the local machine, but the remote mysql Port cannot be remotely connected using the telnet command. Check that the mysql service on the server has been started, and mysql on the server can run normally. telnet localhost 3306 on the server to connect to the server correctly. I was puzzled by this problem, so I went to the Internet to find out whether there were any related solutions. I found that many of them were the reasons for the firewall or remote access permissions of users, it can be queried, but it is never as described by other online friends. Because this mysql was installed when a project management software oKit was installed, it felt like it was something mysql had done, so I found the mysql configuration file my. ini, a rough look in it, found that the original problem lies in this configuration file. This line is found in: bind-address = 127.0.0.1, which is obviously bound to allow only local access to mysql, so comment it and restart the mysql service to solve the problem smoothly.

Many people on the Internet have reported this problem, but have not found any relevant solutions. Therefore, I have posted my experience in the blog community, hoping to help those who encounter the same problem.

BitsCN.com