Enable mysql remote connection in CentOS, remotely manage databases, and centosmysql

Enable mysql remote connection in CentOS, remotely manage databases, and centosmysql

When the server does not run php or install phpmyadmin, it is necessary to remotely manage mysql. Because it is set under CentOS, the title is added with CentOS. the following commands should also be OK in debian and other systems.

Run the following command on the mysql console:

Allow port 3306

PS. The above iptables Add/delete rules are temporary. If the rules take effect after restart, save the changes:
Service iptables save # Or:/etc/init. d/iptables save
In addition,
Vi/etc/sysconfig/iptables # Add the following rule.
-A input-p tcp-m state -- state NEW-m tcp -- dport 3306-j ACCEPT

Navicat can be used in the win system for remote database management software, and several remote software are used. It seems to be quite good to use.