centos7 安装mysql5.7

#获取地址
wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
#更新rpm
sudo yum localinstall mysql80-community-release-el7-3.noarch.rpm 
#sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm 
#列出mysql版本
yum repolist all | grep mysql
#安装工具
yum -y install yum-utils
#禁用MySQL8   
sudo yum-config-manager --disable mysql80-community
#启用MySQL5.7   
sudo yum-config-manager --enable mysql57-community
#文件列表   
cat /etc/yum.repos.d/mysql-community.repo
#列出可用MySQL版本   
yum repolist enabled | grep mysql
#导入公钥
 rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
#安装MySQL   
sudo yum install mysql-community-server
#启动  
systemctl start mysqld
#查看状态  
systemctl status mysqld
#查看root用户密码  
sudo grep 'temporary password' /var/log/mysqld.log
#进入MySQL  
mysql -uroot -p
#重置密码
SET PASSWORD = PASSWORD('xxxx');
#开通远程连接
#格式化展示用户表
select * from user \G
#修改host
update user set host="%" where Host='localhost' and user = "root";
#更新权限
flush privileges;

参考https://cloud.tencent.com/developer/article/1393323https://cloud.tencent.com/developer/article/1393323参考https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/#repo-qg-yum-installinghttps://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/#repo-qg-yum-installing参考https://dev.mysql.com/downloads/repo/yum/https://dev.mysql.com/downloads/repo/yum/