ubuntu mysql 配置过程
2018-07-14 本文已影响0人
qlh831
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;
