Navicat遠端連線不上mysql解決方案

標籤：

內容參考網上的文章，此處只做記錄。

一.can‘t connect to MySql server on ‘192.168.X.X’

這是因為mysql連接埠被防火牆攔截，需用linux執行如下指令：

1.#/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

2.#/etc/rc.d/init.d/iptables save

3.#/etc/init.d/iptables restart

4.查看連接埠是否開啟#/etc/init.d/iptables status

二.1130-host ... is not allowed to connect to this MySql server

1. 

mysql -u root -p password>use mysql;

mysql>update user set host = ‘%‘ where user = ‘root‘;

mysql>FLUSH   PRIVILEGES;

mysql>select host, user from user;

2.

1) 從任何主機串連到mysql伺服器

GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘password‘ WITH GRANT OPTION;

FLUSH   PRIVILEGES;

2)只允許使用者root從ip為192.168.x.x的主機串連到mysql伺服器，並使用password作為密碼

GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘192.168.x.x‘ IDENTIFIED BY ‘password‘ WITH GRANT OPTION;

FLUSH   PRIVILEGES;

如果你想允許使用者root從ip為192.168.x.x‘的主機串連到mysql伺服器的某個資料庫，並使用password作為密碼

GRANT ALL PRIVILEGES ON 資料庫名.* TO ‘root‘@‘192.168.x.x‘ IDENTIFIED BY ‘password‘ WITH GRANT OPTION;

FLUSH   PRIVILEGES;

 

Navicat遠端連線不上mysql解決方案