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

 

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

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

    b.找到mysql->user表

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

    c.将localhost改成%

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

    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

© 版权声明
THE END
喜欢就支持以下吧
点赞0
分享
评论 抢沙发