ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL
来源:互联网 发布:windows平板电脑推荐 编辑:程序博客网 时间:2024/05/13 18:34
当使用Mysql帐号远程登陆的时候,出现类似如下错误:
ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL
解决办法:
1. 改表法(可能是你的帐号不允许从远程登陆,只能在localhost。这个时候只要在localhost的那台电脑,登入mysql后,更改 "mysql" 数据库里的 "user" 表里的 "host" 项,从"localhost"改称"%")
c:/mysql/mysql server 5.1>mysql -u root -p
输入相应密码
mysql>use mysql;
mysql>show tables; (确认一下表user是否存在)
mysql>update user set host='%' where user='root';
mysql>quit
退出mysql
c:/mysql/mysql server 5.1>net stop mysql
c:/mysql/mysql server 5.1>net start mysql
现在远程连接这部mysql服务器就行了
c:/mysql/mysql server 5.1>mysql -h 192.168.1.3 -u root -p
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 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
0 0
- ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL
- 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
- ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL
- 解决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 serve
- 解决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: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.88.160 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.0.207' is not allowed to connect to this MySQL
- 解决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
- 用户
- Poj 1255 覆盖的面积
- 在LINUX配置host文件
- 笔记本快捷键F1~F12与Fn+之间的转换
- C++ GDI+环境的初始化
- ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL
- 爸爸第二季太难看没有温馨感觉,吴镇宇两面三刀掩饰腹黑
- 动态的加载css,js
- Android之与服务端通信一
- linux下将资源文件编进可执行文件
- hdu4814 模拟(黄金分割进制转换)
- onActivityResult在android中的用法
- 在UITableViewCell中获取它的父视图
- My first Blog