MYSQL允许远程访问

1：首先登入MYSQL执行如下：
注意password要改成自己的密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

2：修改MYSQL配置文件：
/etc/mysql/my.cnf
或
/etc/mysql/mysql.conf.d/mysqld.cnf
将

bind-address = 127.0.0.1
注释掉

3：重启MYSQL

sudo /etc/init.d/mysql restart