Shulou(Shulou.com)06/01 Report--

The following brings you about how to open a remote connection with MySQL in one minute. If you are interested, let's take a look at this article. I believe it is more or less helpful for you to open a remote connection after reading MySQL.

1. Log in to mysql

[root@htuidc] # mysql-u root-p

Enter password:

two。 Open a remote connection

GRANT ALL PRIVILEGES ON *. * TO 'root'@'%' IDENTIFIED BY' root@123' WITH GRANT OPTION

Root is the mysql user, and root@123 is the user password

3. Refresh permissions

FLUSH PRIVILEGES

4. Install iptables

Yum install-y iptables

5. Edit the list of open ports, add 3306 ports, and restart the firewall.

-An INPUT-m state-- state NEW-m tcp-p tcp-- dport 3306-j ACCEPT

6. Restart the firewall

!!! So you can be remote!

Read the above details about how to open a remote connection with MySQL in one minute, and whether you have gained anything. If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.