问题:
连接数据库时报错GHost '192.168.100.12' is not allowed to connect to this MySQL serverConnect
解决:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
其他:
1、改表法。
帐号不允许从远程登录,只能在localhost登录。
更改 “mysql” 数据库里的 “user” 表里的 “host” 项,从"localhost"改为"%"
mysql -u root -p
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;
2. 授权法。
1)允许用户使用password从任何主机连接到mysql服务器。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
2)允许用户myuser从ip为192.168.2.10的主机连接到mysql服务器,并使用password作为密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.3' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
3)允许用户从ip为192.168.2.10的主机连接到mysql服务器的dk数据库,并使用password作为密码
GRANT ALL PRIVILEGES ON dk.* TO 'root'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;