CentOS6 turn on MySQL remote access
1. Open MySQL Access port 3306
Modify the firewall configuration file
Vi/etc/sysconfig/iptables
Join Port Configuration
-A input-m state--state new-m tcp-p TCP--dport 3306-j ACCEPT
Reload Rule
Service Iptables Restart
2. Modify the host in the MySQL library
Log in to MySQL;
Use MySQL
Update user set host= '% ' where user= ' root ' and host= ' localhost ';
Remember must also change the password, because at this time the password is invalid, although the local can also be the original password to log in, can be remotely changed host or cannot access
UPDATE user SET Password=password ("root") WHERE user= ' root ';
Flush privileges;
3. Restart MySQL, remote access to the
Service mysqld Restart;
CentOS7 turn on MySQL remote access
CentOS7 This version of the firewall uses the default firewall, unlike the previous version using iptables . Configure the firewall as follows:
1. Turn off the firewall:sudo systemctl stop firewalld.service
2, turn off boot: sudo systemctl disable firewalld.service
3. Install iptables firewall
Execute the following command to install the Iptables firewall:Sudo yum install iptables-services
?
4, configure iptables firewall, open the specified port (CentOS6 same)
5, set up iptables firewall boot:Sudo systemctl enable iptables
6, after the same as CentOS6
Basic operational commands for the firewall under CentOS
CentOS Configuration Firewall Operation instance (start, stop, open, closed port):
Note: The basic operation of the firewall command:
Querying firewall Status:
[[Email protected] ~]# service iptables status
To stop the firewall:
[[Email protected] ~]# service iptables stop
To start the firewall:
[[Email protected] ~]# service iptables start
To restart the firewall:
[Email protected] ~]# service iptables restart
To permanently shut down the firewall:
[Email protected] ~]# chkconfig iptables off
Enable after permanent shutdown:
[Email protected] ~]# chkconfig iptables on
1. View firewall status
[[Email protected] ~]# service iptables status
2, edit the/etc/sysconfig/iptables file. We're going to open 8080 ports and 9990 ports in our instance.
Open/etc/sysconfig/iptables with editor
4. Save the/etc/sysconfig/iptables file and execute it at the terminal
[Email protected] ~]# service iptables restart
5. New view of firewall status
[[Email protected] ~]# service iptables status
6, this time, the server's 8080 and 9990 ports can provide services to the outside.
7, other ports open mode is similar to the open mode.
CentOS7 and CentOS6 How to turn on MySQL remote access