1、修改mysql的配置文件,修改该如下:
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
bind-address = 0.0.0.02、修改ECS安全组,允许mysql端口号通过
3、进入mysql
mysql -u root -p use mysql; update user set host = '%' where user = 'root'; flush privileges; 分四步执行4、重启mysql
sudo systemctl restart mysql //查看是否重启成功 sudo systemctl status mysql