使用navicat远程登录mysql却报错Host is not allowed to connect to this MySQL server
使用navicat远程登录mysql却报错Host is not allowed to connect to this MySQL server原因:就是我们的MySQL不允许远程登录,所以远程登录失败了。解决方法如下:在装有MySQL的机器上登录MySQL‘mysql -u root -p’然后输入密码执行‘use mysql;’执行‘update user set host = ‘%’ where user = ‘root’;’执行刷新MySQL的权限相关表‘FLUSH PRIVI