- 简单粗暴,直接使用phpmyadmina.找到mysql的数据库
b.找到mysql->user表
c.将localhost改成%
d.重启mysql
- 进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