Host is not allowed to connect to this MySQL server解决方法
来源:互联网 发布:优化发展环境整改措施 编辑:程序博客网 时间:2024/06/05 16:29
远程访问MySQL时,提示Host is not allowed to connect to this MySQL server
解决方法如下:
- 在装有MySQL的机器上登录MySQL mysql -u root -p密码
- 执行
use mysql;
- 执行
update user set host = '%' where user = 'root';
这一句执行完可能会报错,不用管它。 执行
FLUSH PRIVILEGES;
经过上面4步,就可以解决这个问题了。
注: 第四步是刷新MySQL的权限相关表,一定要执行
阅读全文
0 0
- host is not allowed to connect to this MySQL server
- Host is not allowed to connect to this MySQL server
- host ... is not allowed to connect to this MySql server
- Host * is not allowed to connect to this MySQL server
- host is not allowed to connect to this MySql server
- Host is not allowed to connect to this MySQL server
- host ... is not allowed to connect to this MySql server
- Host '***' is not allowed to connect to this MySQL server"
- host ... is not allowed to connect to this MySql server
- Host is not allowed to connect to this mysql server,
- Host '***' is not allowed to connect to this MySQL server
- mysql host is not allowed to connect to this mysql server 解决方法
- mysql 远程访问不行解决方法 Host is not allowed to connect to this MySQL server
- Host 'XXX' is not allowed to connect to this MySQL server 解决方法/开启MySQL远程账号
- mysql 远程访问不行解决方法,Host '' is not allowed to connect to this MySQL server
- mysql远程连接报错: Host * is not allowed to connect to this MySQL server,解决方法
- mysql 远程访问不行解决方法 Host is not allowed to connect to this MySQL server
- mysql 远程访问不行解决方法 Host is not allowed to connect to this MySQL server
- jvm系列(五):Java GC 分析
- 整数中1出现的次数
- Faster-RCNN_TF代码解读12:bbox_transform.py
- Scala函数式程序设计原理 week5 List
- Android屏幕适配之dimen适配
- Host is not allowed to connect to this MySQL server解决方法
- python beautifulsoup简用
- Java学习笔记之线程(四):线程的死锁现象
- H5动画,canvas绘制圆环百分比进度的动态效果
- Linux面试常用命令
- 通讯协议的选择,TCP or UDP
- HDU
- 4步教你玩转可视化大屏设计|内附实际操作
- 侧拉菜单