MYSQL - ERROR 1130:Host is not allow
来源:互联网 发布:上海至寻网络骗局 编辑:程序博客网 时间:2024/05/20 22:27
解决mysql数据库远程连接出错ERROR 1130: Host '' is not allowed to connect to this MySQL server
解决方法:基本上第一条就能搞定。
1。 改表法。
可能是你的帐号不允许从远程登陆,只能在localhost。这个时候只要在localhost的那台电脑,登入mysql后,更改 "mysql" 数据库里的 "user" 表里的 "host" 项,从"localhost"改称"%"mysql -u root -pvmwaremysql>use mysql;mysql>update user set host= '%' where user = 'root';mysql>select host, user from user;然后记得刷新数据库,
-------------------------------------------------------------------------------
mysql>use mysql
mysql>update user set host= '%' where user = 'root';
此时如果提示报错,不用管,继续往下走
select host, user from user;
mysql>flush privileges; -- * 这一句是刷新刚才的内容 *一定要刷新,因为操作的是系统授权表。。
-------------------------------------------------------------------------------
2. 授权法。
例如,你想myuser使用mypassword从任何主机连接到mysql服务器的话。GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
如果你想允许用户myuser从ip为192.168.1.3的主机连接到mysql服务器,并使用mypassword作为密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.10.40.54' IDENTIFIED BY '123456' WITH GRANT OPTION;
- MYSQL - ERROR 1130:Host is not allow
- MYSQL - ERROR 1130:Host is not allow
- MYSQL - ERROR 1130:Host is not allow
- [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 '192.168.0.102' 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 '' is not allowed to connect to this mysql server
- MySql - SQL Error (1130): Host IP is not allowed to connect to this MySQL server
- 解决MySQL ERROR 1130 (HY000): Host 'XXX' is not allowed to connect to this MySQL server
- 远程MYSQL 1103错误 ERROR 1130: Host *.*.*.* is not allowed to connect to this MySQL
- MySql - SQL Error (1130): Host IP 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 (HY000): Host 'XXXX' is not allowed to connect to this MySQL server
- 【mysql】ERROR 1130: Host ’...′ is not allowed to connect to this MySQL server
- ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL
- List(3)List的单链式实现的增强版(保留当前位置)
- 黑马程序员_javaIO流(一)
- 基于lucene的nutch索引详解
- 图像处理与计算机视觉:基础,经典以及最近发展(4)图像处理与分析
- 使用iOS4的GestureRecognizers识别手势(Xcode4)
- MYSQL - ERROR 1130:Host is not allow
- iOS 4 Gesture Recognizers 应用实战
- 可访问性不一致
- Linux C编程 简单电话薄(从文件中读取记录,支持插入、删除和保存操作)
- Ubuntu下mysql忘记密码的解决办法
- 《java---简单计算器的实现》
- 信息检索导论:第二章 词项词典及倒排记录表 学习笔记
- GetMessage与PeekMessage的区别
- Eclipse 代码自动补全