Mysql | Mysql的安装与配置（yum）

一、mysql 相关库和rpm的安装

1.下载文件

mkdir -p /opt/software 
cd /opt/software && wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

2.yum安装

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

yum -y install mysql-community-server

二、mysql 启动及查看

1.启动

systemctl start  mysqld.service

2.查看

systemctl status  mysqld.service

3.自启动

systemctl enable  mysqld.service

三、mysql 密码配置

1.查看密码

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

2.登录密码

mysql -uroot -p

3.修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Wec@applet';

若是提示密码安全强度不够，可以通过以下进行调整
1.设置为低强度 set global validate_password_policy=LOW；
2.设置为密码最低长度为6位 set global validate_password_length=6;

4.设置远程登录

use mysql;

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

5.刷新配置

flush privileges;

四、其他用户配置

1.创建用户

CREATE USER 'read'@'%' IDENTIFIED BY 'biyou123456789';

2.设置远程登录

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

3.设置用户权限

GRANT SElECT ON *.* TO 'read'@'%' IDENTIFIED BY "biyou123456789";

4.刷新信息

flush privileges;