How to solve the problem that mysql clients cannot connect to remote mysql

This article focuses on "how to solve the problem that mysql clients can not connect to remote mysql". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to solve the problem that mysql clients can't connect to remote mysql.

Client cannot connect to remote mysql problem

All the configurations are configured, and so are the remote permissions.

The port is open, the firewall is off, and still can not connect to the remote mysql.

Solution:

Modify bind-address=127.0.0.1 under mysql configuration file my.cnf

Is bind-address=192.168.1.* (remote server local ip).

That is, do not set 127.0.01.

At this point, I believe you have a deeper understanding of "how to solve the problem that mysql clients can not connect to remote mysql". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!