Navicat MySQL connection Linux under the problem of MySQL solution

Navicat for MySQL Enterprise Edition 8.1.18 registration code: nave-wagb-zlf4-t23k use Navicat to connect to MySQL under Linux problems encountered.

Error1:2003:can ' t connect to MySQL server on ' localhost '

Workaround:

Turn off the firewall feature of Linux, or set the 3306 port that allows TCP protocol to pass, you can use the following command to open the TCP protocol 3306 port.

1. [Email protected] ~]# more/etc/sysconfig/iptables.
3. -A Rh-firewall-1-input-p TCP--dport 3306-j ACCEPT.

Error2:1130-host ' ClientIP ' is not a allowed to connect to this MySQL server.

Workaround:

Use the root user to log on to Linux, log in to the root user of MySQL, and change the allowed IP address range.

1. [Email protected] ~]# mysql-u root-p
3. MySQL>grant all privileges on * * to ' root ' @ '% ' identified by ' password ' with GRANT option;

This directive allows all users to enter the MySQL server with the root user password, if the '% ' is replaced with ' 192.168.1.100 ', then only the ' 192.168.1.100 ' host can log in.

About navicat MySQL connection Linux under the MySQL database knowledge is introduced here, I hope this introduction can have a harvest for you!

Navicat MySQL connection Linux under the problem of MySQL solution