ERROR 1130: Host 192.168.88.160 is not allowed to connect to this MySQL server
来源:互联网 发布:广点通优化思路 编辑:程序博客网 时间:2024/05/24 01:03
转载1:http://www.blogjava.net/brock/archive/2009/04/13/265323.html
在使用MySQL-Front连接mysql的时候发生的这个错误
ERROR 1130: Host 192.168.88.160 is not allowed to connect to this MySQL server
更改 mysql 数据库里的 user表里的 host项
localhost改称%
mysql -u root -p
mysql>use mysql;
mysql>update user set host = '%' where user ='root';
mysql>flush privileges;
mysql>select 'host','user' from user where user='root';
现在就可以连接了!
权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' with grant option;
=========================
转载2:http://www.mysjtu.com/page/M0/S581/581085.html
报错:1130-host ... is not allowed to connect to this MySql server
- ERROR 1130: Host 192.168.88.160 is not allowed to connect to this MySQL server
- mysql:ERROR 1130: Host '192.168.0.102' is not allowed to connect to this MySQL server
- (zt)ERROR 1130: Host '192.168.1.110' is not allowed to connect to this MySQL server
- SQL Error (1130): Host '192.168.1.100' is not allowed to connect to this MySQL server
- ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL server
- SQL Error (1130): Host '192.168.1.100' is not allowed to connect to this MySQL server
- SQL Error (1130): Host '192.168.1.126' is not allowed to connect to this MySQL server
- 解决ERROR 1130: Host '192.168.1.3' 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
- ERROR 1130 (HY000): Host '192.168.225.128' is not allowed to connect to this MySQL server
- SQL Error (1130): Host '192.168.1.100' is not allowed to connect to this MySQL server
- SQL Error (1130): Host '192.168.1.126' is not allowed to connect to this MySQL server
- 解决ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL server 方法
- 解决ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL server 方法
- [MySQL]MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- 习题3-4,计算器
- 【CodeBlocks 非官方翻译】翻译指导
- 登录 之 通讯机制(socket)
- WPF学习总结和记录(七)-尺寸缩放 定位 上
- 【CodeBlocks 非官方翻译】相关资源[首个预览版(zh_CN)已发布]
- ERROR 1130: Host 192.168.88.160 is not allowed to connect to this MySQL server
- linux内核hlist分析
- 习题3-5,旋转
- php的引用(在变量或者函数、对象等前面加上&符号)
- HDU 3038 How Many Answers Are Wrong
- struts2.1中使用Ajax主题
- 程序的执行过程
- 转载: Visual Studio Unit Test
- UVA 10391 - Compound Words