解决ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL server 方法
来源:互联网 发布:手机拍的图片淘宝 编辑:程序博客网 时间:2024/05/24 00:56
本博客转自: http://blog.csdn.net/july_2/article/details/41896295
1。 改表法。可能是你的帐号不允许从远程登陆,只能在localhost。这个时候只要在localhost的那台电脑,登入mysql后,更改 "mysql" 数据库里的 "user" 表里的 "host" 项,从"localhost"改称"%"
mysql -u root -pvmwaremysql>use mysql;mysql>update user set host = '%' where user = 'root';mysql>select host, user from user;
2. 授权法。例如,你想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;
3. 设置好后,重启机器
4.netstat –atln 查看3306端口是否开放,连接成功后,显示如下:
tcp 0 0 10.10.3.112:3306 10.10.3.114:59976 ESTABLISHED
- 解决ERROR 1130: Host '192.168.1.3' 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 方法
- 解决ERROR 1130: Host '192.168.1.3' 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: Host '192.168.1.3' 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: Host '192.168.0.102' 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
- SQL Error (1130): Host '192.168.1.100' 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
- SQL Error (1130): Host '192.168.1.100' is not allowed to connect to this MySQL server
- SQL Error (1130): Host '192.168.1.126' 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
- SQL Error (1130): Host '192.168.1.100' is not allowed to connect to this MySQL server
- SQL Error (1130): Host '192.168.1.126' 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 '192.168.1.3' is not allowed to connect to this MySQL server
- TCP的基本概念三次握手,四次挥手
- 自定义动画烟花
- Poj2456二分+贪心
- 最新sublime text 3 注册码license分享(亲测有效)
- Ubuntu安装StarUML依赖问题及破解方法
- 解决ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL server 方法
- Centos 7 安装GO语言
- Eclipse如何加入已有工程
- java 获取本地文件字节数组
- CSDN-markdown语法之如何使用LaTeX语法编写数学公式
- <转>MyEclipse快捷键大全
- Spring学习之路第一步 : xml方式实现IOC(控制反转)
- ThreadLocal 线程本地变量
- C和指针 15章 输入输出函数//因为CCFCSP考试要到了,所以这里的话就不写代码实践了,就过一遍