MySQL Linux配置
1、查看初始密码
grep 'password' /var/log/mysqld.log 或 grep 'password' /var/log/mysql/mysqld.log2、修改密码
登入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
