ubuntu mysql 配置过程

1. apt install mysql-server-5.7

2. 如果需要其它机器访问

1) 修改绑定ip

vim /etc/mysql/mysql.conf.d/mysqld.cnf

修改 bind-address = 127.0.0.1

2) 修改可连接ip

use mysql;

update user set host = '%' where user = 'root';

select host, user from user;

systemctl restart mysql.service;