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!
