Linux系统Mysql5.7安装和配置

1.下载mysql57-community-release-el7-8.noarch.rpm 的 YUM 源

wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

2.用yum安装

yum -y install mysql57-community-release-el7-8.noarch.rpm

3.安装MySQL服务器

yum -y install mysql-community-server

4.启动MySQL

systemctl start mysqld.service

5.查看MySQL运行状态

systemctl status mysqld.service

6.在日志文件中找出密码

grep "password" /var/log/mysqld.log

7.登录数据库

mysql -uroot -p

提示输入密码, 将第6步找到的密码复制进去或者输入进去

8.MySQL默认必须修改密码之后才能操作数据库，如下命令修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

如果想设置简单密码, 可调整密码复杂度

查看mysql默认密码复杂度

SHOW VARIABLES LIKE 'validate_password%';

修改密码复杂度(LOW-->只验证密码长度)

set global validate_password_policy=LOW;

修改密码验证的长度

set global validate_password_length=6;

9.开启远程访问限制

grant all privileges on *.* to 'root'@'192.168.10.1' identified by 'password' with grant option;

10.刷新权限使其生效

flush privileges;

11.给指定IP段放开3306端口

firewall-cmd --permanent --add-rich-rule="rule family="ipv4" source address="192.168.10.0/24" port protocol="tcp" port="3306" accept"

给所有ip放开3306端口

firewall-cmd --permanent --add-port=3306/tcp

12.重载防火墙配置

firewall-cmd --reload