阿里云系统ubuntu16.04
1.将/etc/mysql/mysql.conf.d/mysqld.cnf
中的bind-address注释掉
2.进入mysql,输入命令 GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
3.输入FLUSH PRIVILEGES;
4.确保防火墙中有3306端口
大功告成
标签：GRANT,PRIVILEGES,Mysql,远程,mysql,连接,输入
From： https://www.cnblogs.com/tuzichun/p/17079098.html