What should I do if error 2003 occurs in navicat in Linux?

Navicat error 2003 solution steps in Linux:

1. First log in to mysql.

#2. Authorize the user - you need to execute the following statement in mysql (open mysql remote permissions).

use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

Related recommendations: "Navicat for mysql graphic tutorial"

3. Open Navicat - Edit Connection - Click Connection Test.

4. Prompt 2003 error.

5. Comment out bind-address = 127.0.0.1

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

Comment out bind-address = 127.0.0.1 (that is, add # at the beginning of the line) , as follows:

#6. Restart linux.

reboot

7. Then use Navicat to connect to mysql.

The above is the detailed content of What should I do if error 2003 occurs in navicat in Linux?. For more information, please follow other related articles on the PHP Chinese website!