1.进入mysql,开通对外访问
mysql> grant all on *.* to root'%' identified by '123456';
2.修改配置文件
vi /etc/mysql/mysql.conf.d/mysqld.cnf
将bind_address=127.0.0.1注释掉,结果如下:
#bind_address=127.0.0.1
3.重启mysql服务
1.进入mysql,开通对外访问
mysql> grant all on *.* to root'%' identified by '123456';
2.修改配置文件
vi /etc/mysql/mysql.conf.d/mysqld.cnf
将bind_address=127.0.0.1注释掉,结果如下:
#bind_address=127.0.0.1
3.重启mysql服务