Host “xxx” is not allowed to connect to this MySQL server解决
复制远程数据库到本地,连接本地时候报异常:Host “xxx” is not allowed to connect to this MySQL server
意思是"xxx"用户不能连接数据库,解决方式:
1、登录:mysql -u root -ppassword(也可以navicat直接F6)
2、运行:use mysql;
3、运行:update user set host = '%' where user = 'root';
4、运行:FLUSH PRIVILEGES;