1130 -Host '' is not allowed to connect to this MySQL server
来源:互联网 发布:中国人理财数据 编辑:程序博客网 时间:2024/06/05 03:33
改表法。
可能是你的帐号不允许从远程登陆,只能在localhost。这个时候只要在localhost的那台电脑,登入mysql后,更改 "mysql" 数据库里的 "user" 表里的 "host" 项,从"localhost"改称"%"
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;
可能是你的帐号不允许从远程登陆,只能在localhost。这个时候只要在localhost的那台电脑,登入mysql后,更改 "mysql" 数据库里的 "user" 表里的 "host" 项,从"localhost"改称"%"
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;
执行过程中会遇到ERROR 1175 (HY000): You are using safe update mode and you tried to update a table without a WHERE that
uses a KEY column
执行 SET SQL_SAFE_UPDATES = 0;可以去除安全模式 然后就可以改了
改也改了 还是不行
授权法
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION //赋予任何主机访问数据的权限
mysql>FLUSH PRIVILEGES //修改生效
修改之后就OK了,当然我也修改了防火墙和阿里云的安全组.防火墙和安全组分别添加3306端口.防火墙修改见如下链接
防火墙修改
阅读全文
1 0
- host is not allowed to connect to this MySQL server
- Host is not allowed to connect to this MySQL server
- host ... is not allowed to connect to this MySql server
- Host * is not allowed to connect to this MySQL server
- host is not allowed to connect to this MySql server
- Host is not allowed to connect to this MySQL server
- host ... is not allowed to connect to this MySql server
- Host '***' is not allowed to connect to this MySQL server"
- host ... is not allowed to connect to this MySql server
- Host is not allowed to connect to this mysql server,
- Host '***' 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 远程连接错误: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 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】报错:1130-host ... is not allowed to connect to this MySql server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- linux是实时系统还是分时操作系统
- 在maven中安装oracle11g驱动
- 索引
- 【解题报告】选课
- JAVA中获取pid的方法
- 1130 -Host '' is not allowed to connect to this MySQL server
- tcp 三握手和四挥手理解
- 堆 栈
- 海贼王剧情发展
- 在Fragment中怎么调用onActivityResult
- Program Size: Code=x RO-data=x RW-data=x ZI-data=x 的含义
- 关于ajax 上传文件时parseRequest(request)为null的解决方法
- Codeforces 743 D Chloe and pleasant prizes
- java学习之路(3)- public class和class的理解