Solve the problem that Navicat cannot connect to MySQL on the Linux server

At the beginning, I felt sad. The screenshots are as follows:

After some trouble, the solution is as follows:

First, make sure that port 3306 of MySQL on the Linux service is open to the outside world.

Switch to the directory: /etc/sysconfig , edit iptables , and copy this into it: " -A INPUT -p tcp -m tcp --dport 3306 -j ACCEPT ". The effect is as shown in the figure:

Then restart the firewall

service iptables restart

mysql opens root permissions (executed under mysql command)

Grant permissions: grant all privileges on *.* to 'root'@'% 'identified by 'password' with grant option

Refresh the privilege list: flush privileges

Modify the mysqld.cnf file in /etc/percona-server.conf.d directory

Comment out "bind 127.0.0.1"

Uncomment the line “bind-address = 0.0.0.0”

Finally restart mysql

service mysql restart

So happy, it succeeded, the screenshots are as follows:

*****************************************************************************************************

Energy is limited, and there are too many ideas. Just focus on doing one thing well.

I'm just a programmer. Write good code within 5 years, polish every word of technical blogs, and insist on zero copy and originality . The purpose of blogging is to exercise logical reasoning, deepen the systematic understanding of knowledge, and practice writing. If it happens to be helpful to others, it is really a happy thing.

*****************************************************************************************************

Summarize

The above is the editor's introduction to solving the problem that Navicat cannot connect to MySQL on the Linux server. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!