Mysql无法访问,navicat提示:is not allowed to connect to this MySQL server
解决方法:
mysql> use mysql;
mysql> update user set host = '%' where user = 'root';
mysql> FLUSH PRIVILEGES;
>SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
再次连接连接成功。