mysql故障---is not allowed to connect to this MySQL server解决办法

处理方法有二个

1、(如何解决客户端与服务器端的连接(mysql) ：xxx.xxx.xxx.xxx is not allowed to connect to this mysql serv 

) 授权法。例如，你想myuser使用mypassword从任何主机连接到mysql服务器的话。

mysql > GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@‘%’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;

如果你想允许用户myuser从ip为192.168.1.3的主机连接到mysql服务器，并使用mypassword作为密码

mysql > GRANT ALL PRIVILEGES ON *.* TO ‘root’@’192.168.1.3′ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;

mysql > GRANT ALL PRIVILEGES ON *.* TO ‘root’@’10.10.40.54′ IDENTIFIED BY ’123456′ WITH GRANT OPTION;

mysql故障---is not allowed to connect to this MySQL server解决办法

标签：serve   允许   mil   use   故障   mysq   pos   权限   span