Troubleshooting of Linux Mysql 1130 errors

Solve the Linux Mysql 1130 error. When I remotely log on to Mysql through navicat in win32 today, the following error occurs: I don't need to think about it. It must be a Mysql access permission problem. First, log on to the Linux server remotely through the terminal (I use SSH). For security reasons, first change the root user password of Mysql Data:

[Plain] [hadoop @ h1 ~] $ Mysqladmin-u root password 123456 [hadoop @ h1 ~] $ Mysql-uroot-p Enter password: Welcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 13 Server version: 5.0.77 Source distribution Type 'help; 'or' \ H' for help. type '\ C' to clear the buffer. mysql>

Step 2: query the permissions of all Mysql users. unexpectedly, the root user of mysql can only access the database through the local machine. Here we will change the permissions:

[Plain] mysql> update 'user' set 'host' = '%' where 'user' = 'root'; mysql> flush privileges;

 

The operation is successful. Now, you can remotely manage the mysql database through the terminal.