1)可修改配置文件 / etc/mysql/mysql.conf.d/mydqld.cnf 里面的参数!!
2)配置 MySQL 可以远程访问:
mysql> grant all privileges on *.* to root@'%' identified by "123456";
编辑 / etc/mysql/mysql.conf.d/mysqld.cnf, 注释掉:bind-address=127.0.0.1 行
转载于:https://my.oschina.net/u/3136970/blog/1840135