ERROR 1130: Host '192.168.xxx.xxx' is not allowed to connect to this MySQL server(学习笔记)
来源:互联网 发布:1980年电影 知乎 编辑:程序博客网 时间:2024/05/18 01:09
1:25
连接MySQL的时候发生这个错误:
ERROR 1130: Host '192.168.xxx.xxx' is not allowed to connect to this MySQL server
1、改表法
MySQL server不允许你的远程访问,在MySQL server主机登入mysql后,更改"mysql" 数据库里的 "user" 表里的 "host" 项,"localhost"改成"%"
mysql>mysql -u root -p
mysql>use mysql;
mysql>update user set host = '%' where user ='root';
mysql>select host user from user where user ='root';
2、授权法
在MySQL服务器端通过授权自设定一个用户名“root”和口令密码“MySQL2010!”客户可以通过此设置定的用户名和口令密码从任何主机连接到MySQL服务器,设定的用户名和口令密码与本地主机MySQL账号和密码不冲突。
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MySQL2010!';
mysql>flushprivileges; //刷新
指定固定IP访问:在IP为192.168.56.101主机访问MySQL服务器,那么要在MySQL服务器端给其设定一个用户名和口令密码使其登陆访问,设定用户名"hoot","LOVEyou2017@"为口令密码。
mysql>GRANT ALL PRIVILEGES ON *.* TO'hoot'@'192.168.56.101'IDENTIFIED BY'LOVEyou2017@';
mysql>flush privileges; //刷新
- ERROR 1130: Host '192.168.xxx.xxx' is not allowed to connect to this MySQL server(学习笔记)
- 解决MySQL ERROR 1130 (HY000): Host 'XXX' is not allowed to connect to this MySQL server
- ERROR 1130: 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
- Host ''xxx.xx.xxx.xxx'' is not allowed to connect to this MySQL server
- host'xx.xxx.xxx.xxx' is not allowed to connect to this mysql server
- 【MySQL】1130- Host“XXX” is not allowed to connect to this MySql server
- Host 'xx.xx.xxx.xxx' is not allowed to connect to this MySQL server
- 连接MySQL数据库报 "Host XXX.XXX.XXX.XXX is not allowed to connect to this MySQL server " 解决办法。
- mysql 远程连接--Host'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server
- 主机连接虚拟机MySQL报错:Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server
- MySQL:message from server: "Host xxx is not allowed to connect to this MySQL server"
- 【转】ERROR 1130: Host 'xxx.xxx.x.x' is not allowed to connect to thisMySQL server
- message from server: "Host 'xxx' is not allowed to connect to this MySQL server"
- message from server: "Host 'xxx' is not allowed to connect to this MySQL server的解决
- XXX is not allowed to connect to this MySQL server
- Host 'XXX' is not allowed to connect to this MySQL server 解决方法/开启MySQL远程账号
- 【解决】Mysql关于Host \'XXX\' is not allowed to connect to this MySQL server 的问题
- 搭建angular2 的环境遇到的问题npm ERR! Windows_NT 10.0.14393 npm ERR! argv "C:\\Program Files\\nodejs\\node.exe
- Launcher
- angularjs之获取用户信息
- 显示回退的暴力字符串匹配算法.java
- 才发现截屏图片直接粘贴显示不出来
- ERROR 1130: Host '192.168.xxx.xxx' is not allowed to connect to this MySQL server(学习笔记)
- 学习STL的笔记
- 性能优化,进无止境---内存篇(下)
- 清除input的缓存
- OkHttp 之 token使用
- RedBlackTest.java
- mac chrome浏览器快捷键
- 解决eclipse报PermGen space内存溢出异常的问题
- CUDA编程系列学习-从入门到放弃