ERROR 1130: Host '' is not allowed to connect to thisMySQL server
来源:互联网 发布:阿里云邮箱客户端下载 编辑:程序博客网 时间:2024/06/06 02:39
今天1网友求助,说自己PHPmyadmin可以正常连接数据库,使用sqlyog报错:
解决方法:
1,修改user表
mysql -u root -p
mysql>use mysql;
mysql>update user set host = '172.27.241.1' where user ='root';
mysql>flush privileges;
2.指定授权
mysql -u root -p
mysql>use mysql;
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.27.241.1' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
ERROR 1130: Host '172.27.214.1' is not allowed to connect to thisMySQL server
解决方法:
1,修改user表
mysql -u root -p
mysql>use mysql;
mysql>update user set host = '172.27.241.1' where user ='root';
mysql>flush privileges;
2.指定授权
mysql -u root -p
mysql>use mysql;
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.27.241.1' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
mysql>flush privileges;
注意:
1.精准授权,即那个账号,哪台主机,需要哪种权限,必须写明,最好不要泛授权;
2.记着执行完每条命令要flush privileges;
1 0
- ERROR 1130: Host '' is not allowed to connect to thisMySQL server
- 【转】ERROR 1130: Host 'xxx.xxx.x.x' is not allowed to connect to thisMySQL server
- ERROR 1130: Host '192.168.1.3' is not allowed to connect to thisMySQL server
- navicat1130 ERROR 1130: Host '192.168.1.3' is not allowed to connect to thisMySQL server
- ERROR 1130: Host 'A'is not allowed to connect to this MySQL server
- ERROR 1130: Host 'A'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
- 转 Error No. 1130 Host '*.*.*.*' is not allowed to connect to this MySQL server
- ERROR 1130: Host 'A'is not allowed to connect to this MySQL server
- SQL Error (1130): Host IP 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
- 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
- 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
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- [MySQL]MySQL Error 1130 Host 'localhost' 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
- iOS 8 自适应 Cell
- Unity3D表面着色器(Surface Shader)资料整合
- 三十款国外IES灯光经典素材整理n
- 三十款国外IES灯光经典素材整理i
- linxu mp3转aac, aac转mp3, mp4转mp3 mp4转aac
- ERROR 1130: Host '' is not allowed to connect to thisMySQL server
- C# 中通过CancellationTokenSource实现对超时任务的取消
- [web安全] XSS的原理与分类
- 关于PKCS5Padding与PKCS7Padding的区别
- Failed to find the style corresponding to the id 2147418306 (6 similar errors not shown)
- Java数据成员的默认值
- 南京城游记
- linux kernel ABC #2 LVM
- css在360浏览器的兼容问题