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插图1

    c.将localhost改成%

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

    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

人已赞赏
PHP学习笔记技术杂烩网站建设

fastadmin 页面修改技巧之三:数据类型兼容

2020-11-17 17:53:19

Linux学习笔记技术杂烩

通过修改代码解决宝塔面板强制绑定手机号

2020-11-22 15:42:30

0 条回复 A文章作者 M管理员
    暂无讨论,说说你的看法吧
个人中心
购物车
优惠劵
今日签到
有新私信 私信列表
搜索