Navicat: unknown error 1130,unknown error 1045

created at 09-13-2021 views: 7

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

created at:09-13-2021
edited at: 05-30-2022: