1.修改绑定IP
~# vim /etc/mysql/mysql.conf.d/mysqld.cnf
修改 bind-address = 0.0.0.0
2.重启mysql
service mysql restart
3.添加远程用户
mysql>GRANT ALL PRIVILEGES ON *.* TO 'remoteuser'@'%' IDENTIFIED BY 'remote' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;
添加远程用户:remoteuser,登录密码:remote。
4.授权阿里云ECS安全组3306端口