Mysql cannot be remotely logged on. mysql Login

Mysql cannot be remotely logged on. mysql Login

When using TCP/IP to connect to mysql, the following error occurs:
Can't connect to MySQL server on 'xxx. xxx. '(111)

This error occurs.

After repeated tossing:
Check whether the IP address is correct. The user permission is available (remote IP connection is supported). The configuration file is used to unbind the local IP address...
A waste of half an hour... See the following paragraphs ,,,

If you directly run the mysql command in the linux shell Command Line and can smoothly connect to MySQL, the query statement execution is also normal, but if you execute the stop slave command; the ERROR 2013 (HY000): Lost connection to MySQL server during query problem occurs randomly. If you write the operation command to the script file and then execute the script file, there will inevitably be Lost connection to MySQL server at 'reading initial communication packet ', system error: 111 If any remote access error occurs, it can be considered that the system has firewall and other restrictions, but the strange cramps are puzzling. The final solution is to add a startup parameter skip-name-resolve in the [mysqld] section in my. cnf. However, the reason is still unknown.

As mentioned above... It's amazing to solve the problem .... Thank you again for the amazing du Niang ..

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.