host is not allowed to connect to this MySQL
来源:互联网 发布:mysql 5.5 linux安装 编辑:程序博客网 时间:2024/05/19 18:44
解决办法:
1. 改表法(可能是你的帐号不允许从远程登陆,只能在localhost。这个时候只要在localhost的那台电脑,登入mysql后,更改 "mysql" 数据库里的 "user" 表里的 "host" 项,从"localhost"改称"%")
2. 授权法
例如,你想myuser使用mypassword从任何主机连接到mysql服务器的话。
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
如果你想允许用户myuser从ip为192.168.*.*的主机连接到mysql服务器,并使用mypassword作为密码
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
- host is not allowed to connect to this MySQL server
- host is not allowed to connect to this MySQL
- Host is not allowed to connect to this MySQL server
- host ... is not allowed to connect to this MySql server
- Host * is not allowed to connect to this MySQL server
- host is not allowed to connect to this MySql server
- Host is not allowed to connect to this MySQL server
- host ... is not allowed to connect to this MySql server
- Host '***' is not allowed to connect to this MySQL server"
- host ... is not allowed to connect to this MySql server
- host is not allowed to connect to this mysql
- Host is not allowed to connect to this mysql server,
- Host '***' is not allowed to connect to this MySQL server
- host is not allowed to connect mysql
- Host '*' is not allowed to connect to this MariaDB server
- host XXX is not allowed to connect to this MariaDB
- Host '*' is not allowed to connect to this MariaDB server
- [MySQL]MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- java中的标准I/O流与文件2(J2SE入门17)
- Ant脚本管理Glassfish
- Hibernate对多表关联查询
- man命令
- OllyDbg小知识【2】- 躲过程序的初始化Anti-Debug
- host is not allowed to connect to this MySQL
- android获取系统时间
- Android ListView控件基本用法
- 浅谈Service Manager成为Android进程间通信(IPC)机制Binder守护进程之路
- Hibernate缓存管理
- 双石CRM客户关系管理专家
- rsync+inotify实现数据的实时备份实例
- 102、Makefile
- 查询 schedule