Centos7 mysql5.7安装全流程

安装wget
yum install -y wget
下载mysql源
wget http://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm
安装mysql源
rpm -Uvh mysql57-community-release-el7-10.noarch.rpm
检查签名
rpm --checksig mysql57-community-release-el7-10.noarch.rpm
创建公钥文件
gpg --export -a “公钥（安装mysql源后会提示公钥）” > “公钥”.asc
rpm导入公钥
rpm --import “公钥”.asc
mysql url导入公钥
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
安装mysql服务
 yum install  -y  mysql-community-server
启动mysql服务
service mysqld start
检查mysql服务
service mysqld status
systemctl status mysqld.service
查看mysql临时密码
grep 'temporary password' /var/log/mysqld.log
登录mysql
mysql -uroot -p
“输入临时密码”
修改登录密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';
关闭密码策略
mysql> set global validate_password_policy=0; 
修改密码长度
set global validate_password_length=（1-16）;
授权其它机器登录
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
 
FLUSH  PRIVILEGES;