telnet mysql時出現：is not allowed to connect to this MySQL serverConnection closed by foreign host問題的解決

標籤：.net   jsb   命令   connect   描述   圖片   fill   sdn   closed   

有時候telnet一個mysql伺服器的時候會出現：

Host ‘192.168.0.1‘ is not allowed to connect to this MySQL serverConnection closed by foreign host.

這個原因是因為索要連結的mysql資料庫只允許其所在的伺服器串連，需要在mysql伺服器上設定一下允許的ip許可權，如下：

串連命令端：

1.串連mysql

mysql -u root -p

2.授權

grant all privileges on *.* to ‘root‘@‘192.168.0.1‘ identified by ‘123456‘;

當然，如果想給所有ip都賦予許可權，則這樣：

grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘123456‘;

3.使授權立即生效

flush privileges;

然後再遠程telnet或者串連這個mysql資料庫就可以成功了。

 

參考

77854690

telnet mysql時出現：is not allowed to connect to this MySQL serverConnection closed by foreign host問題的解決