mysql故障---is not allowed to connect to this MySQL server解決辦法

標籤：serve   允許   mil   use   故障   mysq   pos   許可權   span   

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這是告訴你沒有許可權串連指定IP的主機，下面我們來看看解決辦法。

處理方法有二個

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解決辦法