MYSQL - ERROR 1130:Host is not allow
来源:互联网 发布:centos hadoop 安装 编辑:程序博客网 时间:2024/05/21 01:31
解决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
- C语言中的字符串
- Linux 查看文件内容的命令
- web前端面试集锦
- Point cloud Library
- virtulBox Linux 设置
- MYSQL - ERROR 1130:Host is not allow
- 雪(一)
- HTML5中CANVAS
- Android 实现QQ第三方登录
- 神经网络学习笔记(九):多层感知机(上)
- 康托展开
- eclipse 去掉Eclipse打开后定期弹出Usage Data Upload对话框
- c# 智能电饭锅服务器 tcp连接 笔记
- linux expect