MySQL安装后初始设置

允许用户远程登录

1. 创建用户

create user 'root'@'%' identified by '***';
grant all on *.* to 'root'@'%';

2. 修改/etc/mysql/mysql.conf.d/mysqld.cnf

bind-address = 0.0.0.0

3. 重启服务service mysql restart