Shulou(Shulou.com)06/01 Report--

Editor to share with you what to do when there is a 2003 error in navicat connection, I believe most people don't know much about it, so share this article for your reference. I hope you will gain a lot after reading this article. Let's learn about it together.

2003 workaround when connecting to navicat:

(1) check which ports are opened netstat-anp

127.0.0.1 3306-means that the mysql database can only be accessed locally

(2) We changed 127.0.0.1 VOL3306 to 0.0.0.0VOUR 3306, so that all users can access the mysql database remotely.

Open / etc/mysql/mysql.cnf to find bind-address= 127.0.0.1 and change it to bind-address= 0.0.0.0

(mysql5.7.24 version, configuration file directory is: / etc/mysql/mysql.conf.d/mysqld.cnf)

Restart takes effect

Command: service mysql restart

(3) when you test the connection to mysql after step 2, you will still get an error: "1130 is not allowed to connect to this MySql server". This is because there is no permission to open it.

Execute under the linux server:

Enter 1.mysql-u root-p, enter the password, and log in

two。 Authorize remote users to log in

1. Authorize all root users:

GRANT ALL PRIVILEGES ON *. * TO 'root'@'%' IDENTIFIED BY' root user password 'WITH GRANT OPTION

two。 Authorize the root user of the specified IP:

GRANT ALL PRIVILEGES ON *. * IP address specified by TO root@' 'IDENTIFIED BY' root user password 'WITH GRANT OPTION

3. You can also authorize the specified table, which is not so troublesome, anyway, it is used locally.

3. Overload authorization table: FLUSH PRIVILEGES

4.exit exits Mysql

(4) the connection is tested and the connection is successful.

The above is all the contents of the article "what to do if there are 2003 errors in navicat connection". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.