on how to implement remote connection of MySQL database on cenos7.0

1. Set the permissions that MySQL allows other clients to control

Mysql-uroot-p     #此处为本地linux帐号密码

Select User,host from Mysql.user; #查看mysql表对应username的host

Grant Usage on * * to [e-mail protected] identified by ' 111111 ';    #设置root允许ip192. Permissions for 168.1.200IP control

2. Temporarily shut down the firewall test to see if the connection is successful

In this note, many of the internet is using the service iptables Stop command to shut down the firewall, in fact, CentOS 7.0 by default is used by the firewall as a firewall, so

We're shutting down FIREWALLD, not iptables.

Close command

This is managed only with database connections, which successfully

on how to implement remote connection of MySQL database on cenos7.0