ERROR 1130 (HY000): Host 'xxxxxx' is not allowed to connect to this MySQL server解决办法
来源:互联网 发布:淘宝开店卖q币 编辑:程序博客网 时间:2024/05/22 16:46
出现该问题的原因是没有权限连接指定IP的主机(即MySQL数据库所在主机),解决办法:
) 授权法。
如果你想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;
当然,以上的前提是你要访问的数据库允许远程登录,修改办法
编辑 vim /etc/mysql/my.cnf
将bind-address = 127.0.0.1中的127.0.0.1改为0.0.0.0
- ERROR 1130 (HY000): Host 'xxxxxx' 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 ERROR 1130 (HY000): Host 'XXXX' is not allowed to connect to this MySQL server
- mysql远程连接:ERROR 1130 (HY000): Host '*.*.*.*' is not allowed to connect to this MySQL server解决办法
- mysql远程连接:ERROR 1130 (HY000): Host '*.*.*.*' is not allowed to connect to this MySQL server解决办法
- mysql远程连接:ERROR 1130 (HY000): Host '*.*.*.*' is not allowed to connect to this MySQL server解决办法
- ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server
- 解决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
- ERROR 1130 (HY000): Host '10.117.1.13' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host '172.16.0.123' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host '113.57.150.82' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host 'xxx' is not allowed to connect to this MySQL server
- IT忍者神龟之mysql远程连接:ERROR 1130 (HY000): Host '*.*.*.*' is not allowed to connect to this MySQL server解决
- SQLSTATE[HY000] [1130] Host '139.129.142.19' is not allowed to connect to this MySQL server 的解决办法
- ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL解决方式
- Linux程序设计第八章
- 深入Java虚拟机:JVM中的Stack(栈)和Heap(堆)
- 转关于JNI使用
- Android学习笔记之AndroidManifest.xml文件解析
- 自定义标签(JspFragment类、invoke方法、开发带属性的标签)
- ERROR 1130 (HY000): Host 'xxxxxx' is not allowed to connect to this MySQL server解决办法
- Linux程序设计第九章
- Java 三层架构ssh
- Python 文件操作
- 解决android SDK更新不了问题
- 深入浅出Node.js(六):Buffer那些事儿
- Linux程序设计第十一章
- 深入研究ReentrantLock(重入锁)之引出话题篇
- Hadoop集群配置