ERROR 1130 (HY000): Host '113.57.150.82' is not allowed to connect to this MySQL server
来源:互联网 发布:centos6.5编译安装php 编辑:程序博客网 时间:2024/05/21 12:47
报错的原因是我的本机不能连接远程的MySQL数据库;
解决办法:
在远程数据库那里输入: mysql -u root -p
然后输入密码,然后: GRANT ALL PRIVILEGES ON . TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
这个里的myuser
是可以访问数据库的用户名;
这个里的mypassword
是和上面用户对应的密码;
我的输入是: GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
最后还有一个命令: FLUSH PRIVILEGES;
这个很重要,没有是操作不成功的。
然后我们就可以在其他电脑上连接了。 mysql -h mysql所在机器的ip -u root -p
如: mysql -h 192.168.1.1 -u root -p
接下来输入密码就可以了。
0 0
- ERROR 1130 (HY000): Host '113.57.150.82' 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
- ERROR 1130 (HY000): Host 'xxxxxx' 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 'localhost' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host 'xxx' 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解决办法
- IT忍者神龟之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解决方式
- SQLSTATE[HY000] [1130] Host 'DESKTOP-O0CRH8F' is not allowed to connect to this MySQL server
- 第九天 Android学习总结(内容提供者)
- guice入门-多数据源
- Can you solve this equation?
- Java语言基础数据类型的概述和分类
- PHP返回的json字符串包含的特殊字符
- ERROR 1130 (HY000): Host '113.57.150.82' is not allowed to connect to this MySQL server
- Tomcat Session
- [00315]字符串转换为日期
- 使用intellj idea 搭建本地开发环境
- java微信开发实战
- CNN(卷积神经网络)、RNN(循环神经网络)、DNN(深度神经网络)的内部网络结构有什么区别?(知呼回答)
- 技术书籍、GitHub
- 不管你做什么工作,这5项能力必须掌握!
- 加载一个react native 页面