In Windows, Navicat connects to MySql in CentOS.

Direct method:

First, configure the iptables rules for the firewall under CentOS:

# Vim/etc/sysconfig/iptables

Add the following rules to the rule:

-A input-m state-state NEW-m tcp-p tcp-dport 22-j ACCEPT
-A input-m state-state NEW-m tcp-p tcp-dport 80-j ACCEPT
-A input-m state-state NEW-m tcp-p tcp-dport 3306-j ACCEPT

Note: The firewall opens port 80 for http and Port 3306 for connection to MySql.

# Service iptables restart

Then configure MySQL to allow remote login:

Connect to the Mysql database in CentOS first

# Mysql-uroot-proot

Run

> Grant all privileges on *. * TO 'root' @ '% 'identified BY 'Your _ password' with grant option;

Then execute

> Flush privileges;

Refresh the permission without restarting the MySql service.

After completing the configuration, open Navicat in Windows to directly connect to the database in CentOS.