MySQL Linux配置

1、查看初始密码

grep 'password' /var/log/mysqld.log

或
grep 'password' /var/log/mysql/mysqld.log

2、修改密码

登入mysql之后

alter user user() identified by "root";

3、配置mysql允许远程连接

mysql默认情况下是禁止远程访问的

可以先查看user表

select user,authentication_string,host from user;

默认都是localhost

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

%允许来自任何ip的连接

最后记得一定要FLUSH PRIVILEGES;

设置防火墙

添加端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent

重启防火墙
systemctl restart firewalld.service

查询防火墙开放端口
systemctl restart firewalld.service

如果此时显示firewalld is not running，说明防火墙还没开启，先开启 

 systemctl start firewalld