解决MySQL ERROR 1130 (HY000): Host 'XXX' is not allowed to connect to this MySQL server
来源:互联网 发布:实用办公软件基础教程 编辑:程序博客网 时间:2024/05/14 04:16
1、登录mysql服务器
格式: mysql -h主机地址 -u用户名 -p密码注意:-p密码之间没有空格
2、赋予权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'IP地址' IDENTIFIED BY '密码' WITH GRANT OPTION;
或者:
GRANT ALL ON 数据库名.* TO root@IP地址 IDENTIFIED BY '密码';
FLUSH PRIVILEGES;
0 0
- 解决MySQL ERROR 1130 (HY000): Host 'XXX' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host 'xxx' is not allowed to connect to this MySQL server
- 解决MySQL ERROR 1130 (HY000): Host 'XXXX' is not allowed to connect to this MySQL server
- 解决ERROR 1130 (HY000): Host '192.168.1.9' is not allowed to connect to this MySQL server
- IT忍者神龟之mysql远程连接:ERROR 1130 (HY000): Host '*.*.*.*' is not allowed to connect to this MySQL server解决
- ERROR 1130 (HY000): Host 'xxxxxx' is not allowed to connect to this MySQL server解决办法
- ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host '192.168.225.128' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host '10.117.1.13' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host '172.16.0.123' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host '113.57.150.82' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL解决方式
- ERROR 1130: Host 'xxx' is not allowed to connect to this MySQL server
- mysql远程连接:ERROR 1130 (HY000): Host '*.*.*.*' is not allowed to connect to this MySQL server解决办法
- mysql远程连接:ERROR 1130 (HY000): Host '*.*.*.*' is not allowed to connect to this MySQL server解决办法
- mysql远程连接:ERROR 1130 (HY000): Host '*.*.*.*' is not allowed to connect to this MySQL server解决办法
- [MySQL登录错误] ERROR1045 (28000): Access denied for user 'omonroy'@'20.112.251.19' (using password:YES)
- UCSD非易失性存储工作室——耐久性主存的铺路人
- Linux招聘技术面试题
- Error inflating class错误
- Git Notes
- 解决MySQL ERROR 1130 (HY000): Host 'XXX' is not allowed to connect to this MySQL server
- 王艾辉:4.28白银中短线思路,意料之中意料之外
- mysql select * into OUTFILE 不会锁表
- 编程之美2.18—数组分割
- [MySQL 错误]ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not
- html5 的header区
- (素材源码)猫猫学IOS(二十九)UI之Quartz2D自定义下载控件
- Web_PHP_DedeCMS_畅言评论模块操作使用说明;
- [分享]麦子学院助教是怎样一群人