Navicat: unknown error 1130，unknown error 1045

error 1130¶

Use Navicat to link MySQL, and an error like this appears:

unknown error 1130

solution:¶

Log in to mysql on the server and enter use mysql:

root@localhost 09:07:  [mysql]> update user set host = '%' where user = 'root';
Query OK, 1 row affected (0.07 sec)

root@localhost 09:12:  [mysql]> flush privileges;
Query OK, 0 rows affected (0.02 sec)

Then use the Navicat link again to appear:

error 1045¶

unknown error 1045

solution¶

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

root@localhost 09:13:  [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.02 sec)

root@localhost 09:14:  [mysql]> flush privileges;
Query OK, 0 rows affected (0.02 sec)

summary¶

this type of error is probably caused by the permissions set for the root user in mysql in the database

Hope this will help you