mysql远程连接 Host * is not allowed to connect to this MySQL server

1. 简单粗暴,直接使用phpmyadmina.找到mysql的数据库

   

   b.找到mysql->user表

   

   c.将localhost改成%

   

   d.重启mysql

2. 进mysql,使用命令行mysql -u root -p

   mysql>use mysql;

   mysql>update user set host =”%” where user =”root”;

   mysql>flush privileges;

文章来源于互联网:mysql远程连接 Host * is not allowed to connect to this MySQL server