1、修改配置文件/etc/mysql/mysql.conf.d/mysqld.cnf
vim /etc/mysql/mysql.conf.d/mysqld.cnf
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
...
bind-address = 0.0.0.0 #将此处修改为0.0.0.0
#
...
2、进入mysql数据开启root允许所有主机访问
use mysql;
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES
