Shulou(Shulou.com)06/01 Report--

Today I tried to use the Navicat tool to remotely link to MySQL Times 1045 error!

The error message is as follows:

1045 access denied for user 'root'@192.168.0.101'

The reason is that the database forbids remote links

Root@mysql01 00:32: [(none)] > use mysql

Database changed

Root@mysql01 00:32: [mysql] > update user set host='%' where user='root'

Query OK, 1 row affected (0.01sec)

Rows matched: 1 Changed: 1 Warnings: 0

Root@mysql01 00:32: [mysql] > flush privileges

Query OK, 0 rows affected (0.01 sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.