ERROR 1130: Host 'HostName' is not allowed to connect to this MySQL server
来源:互联网 发布:kafka leader选举算法 编辑:程序博客网 时间:2024/06/05 02:23
1、控制台登录mysql
mysql -uroot -ppassword
2、执行
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'rootpasswd' WITH GRANT OPTION;
说明:%为允许任何其它IP登录,也可以指定具体IP地址。另外如果想要修改登录密码可以重新执行以上代码。
3、退出
\q
测试
mysql -uroot -ppassword -h ip
说明:ip为具体的地址
- ERROR 1130: Host 'HostName' is not allowed to connect to this MySQL server
- [MySQL]MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- Host 'HostName' is not allowed to connect to this MySQL server
- Host 'HostName' is not allowed to connect to this MySQL server
- Host 'HostName' 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 - 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 'A'is not allowed to connect to this MySQL server
- winform 子界面关闭问题
- 编程之美 NIM游戏与NIM扩展游戏的讨论及解
- QT槽与信号的教训
- POJ 1003
- CSharp - Working principles about Thread, Process, Multithreading, DeadLock, Lock
- ERROR 1130: Host 'HostName' is not allowed to connect to this MySQL server
- 黑马程序员——单例设计模式
- C# 界面随父界面大小比例变化
- maps 和 reduces 的数量
- Prime ring problem
- Junit4 新断言语法介绍(转)
- uva 12097 - Pie(二分,4级)
- 设计模式-06-适配器模式
- YUM常用命令介绍