Navicat connecting to MySQL in a virtual machine (CentOS)

Directly on the method: first configure the CentOS firewall iptables rule:

1. # vim /etc/sysconfig/iptables

Add the following rules to them:

1. -A INPUT -m state –state NEW -m tcp -p tcp –dport 22 -j ACCEPT
2. -A INPUT -m state –state NEW -m tcp -p tcp –dport 80 -j ACCEPT
3. -A INPUT -m state –state NEW -m tcp -p tcp –dport 3306 -j ACCEPT

Description: Firewall open HTTP with 80 ports and 3306 ports connected to MySQL.

1. # service iptables restart

Then configure MySQL to allow remote login: Connect the MySQL database in CentOS first

1. # mysql -uroot -proot

Perform

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

Then execute the next

1. > flush privileges;

Do not restart the MySQL service. After the final configuration is complete, open the Navicat under Windows to connect directly to the database under CentOS.

Navicat connecting to MySQL in a virtual machine (CentOS)