1130 - Host ‘win7' is not allowed to connect to this mysql server
来源:互联网 发布:百度网盘无法连接网络 编辑:程序博客网 时间:2024/05/29 15:17
远程连接自己或别人的mysql时,弹出了提示:“1130 - Host ‘win7' is not allowed to connect to this mysql server”,意思是主机不允许连接到mysql服务器,不允许的原因是连接方没有足够的权限。解决办法有两个:
方法一:
1)允许任何用户连接:
update user set host='%' where user='root';
flush privileges;
2)允许ip 192.168.1.3连接
update user set host='192.168.1.3' where user='root';
flush privileges;
3)允许ip是192.168.1开头的任何用户连接:
update user set host='192.168.1%' where user='root';
flush privileges;
方法二:
1)允许任何用户使用root/root连接
grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
flush privileges;
2)允许用户root从ip为192.168.1.3的主机连接到mysql服务器,并使用root作为密码
grant all privileges on *.* to 'root'@'192.168.1.3' identified by 'root' with grant option;
flush privileges;
3)允许用户root从ip为192.168.1.3的主机连接到mysql服务器的dk数据库,并使用root作为密码
grant all privileges on dk.* to 'root'@'192.168.1.3' identified by 'root' with grant option;
flush privileges;
- 1130 - Host ‘win7' is not allowed to connect to this mysql server
- 1130 - Host ‘win7' 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,
- 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
- 是一坨屎还是一堆养分,取决于你所在的位置
- 【揭秘CPU占用率高的原因】
- 群讨论--函数索引 -位图索引 -预防死锁
- dstat的使用
- maven 配置篇 之 settings.xml
- 1130 - Host ‘win7' is not allowed to connect to this mysql server
- Activity的跳转与传值
- The resource is not on the build path of a PHP project
- 使用maven2 进行团队配置
- 对控制反转/依赖注入的理解
- oracle & 和 ' 特殊字符处理
- 提高软件测试效率方法探讨
- RADOS分布式对象存储原理简介
- maven2 建立统一的管理站点