Mysql:is not allowed to connect to this MySQL server
来源:互联网 发布:网络机顶盒的价格 编辑:程序博客网 时间:2024/06/06 19:01
如果你想连接你的mysql的时候发生这个错误:
ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL server
解决方法:
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 'root'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.10.40.54' IDENTIFIED BY '123456' WITH GRANT OPTION;
3、个人收藏
USE mysql;
UPDATE USER SET PASSWORD=PASSWORD('root') WHERE USER='root' ;
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Mysql:is not allowed to connect to this MySQL server
- Android中使用Handler造成内存泄露的分析和解决
- 错误5error LNK2019: 无法解析的外部符号 "public: virtual __thiscall CvvImage::~CvvImage(void)" (??1CvvImage@@U
- oracle 11g RAC 限制指定IP访问
- 保护模式学习笔记:GDT
- 如何往云桌面传送文件
- Mysql:is not allowed to connect to this MySQL server
- DrawerLayout去除阴影
- 在刚开始安装Java时遇到的问题
- GitHub使用教程详解(上)——官网操作指南[翻译]
- svn使用记录
- QTableview QSqlTableModel如何最恰当地只显示一个表中的某几个字段的数据
- LeetCode - 21. Merge Two Sorted Lists
- Java 8 加密架构中Oracle提供者总结
- ftp服务器后文件显示的时间与实际时间不一致