MySQL 5.7配置远程连接

• 进入mysql client

$ mysql -uroot

• 选择数据库

mysql> use mysql;

• 配置远程连接

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

• 重启mysql服务

$ sudo service mysqld restart;