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


  1. 简单粗暴,直接使用phpmyadmin

    a.找到mysql的数据库

    image.png

    b.找到mysql->user表

    image.png

    c.将localhost改成%

    image.png

    d.重启mysql

  2. 进mysql,使用命令行

    mysql -u root -p

    mysql>use mysql;

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

    mysql>flush privileges;

发表评论