在使用Navicat for MySQl访问远程mysql数据库，出现报错，显示“1130 - Host'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server“。解决办法如下：
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION
把他运行一下就行了。
相关文章
- 连接远程数据库时出现 SSH: expected key exchange group packet from server / 2003 - Can't connect to MySQL server on 'XXX' (10038) / 1130 - Host 'XXX' is not allowed to connect to this MySQL server
- 访问远程mysql数据库，出现报错，显示“1130 - Host'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server“
- 最近使用Navicat for MySQl访问远程mysql数据库，出现报错，显示“2003- Can't connect MySQL Server on 'localhost'(10038)“。