CentOS7使用rpm包下载最新MySQL方案

安装MySQL

1.访问国内MySQL镜像站

中国科学技术大学镜像站
阿里镜像站
清华镜像站

点击直接跳转下载地址
以中国科学技术大学镜像站为例：






在此页面下载MySQL8.0所需依赖包，使用ctrl+f 快速查找
右键复制链接

mysql-community-client-8.0.31-1.el7.x86_64.rpm
mysql-community-client-plugins-8.0.31-1.el7.x86
mysql-community-common-8.0.31-1.el7.x86_64.rpm
mysql-community-icu-data-files-8.0.31-1.el7.x86
mysql-community-libs-8.0.31-1.el7.x86_64.rpm
mysql-community-server-8.0.31-1.el7.x86_64.rpm

在服务器上使用wget下载

wget https://mirrors.ustc.edu.cn/mysql-repo/yum/mysql-8.0-community/el/7/x86_64/mysql-community-client-8.0.31-1.el7.x86_64.rpm

wget https://mirrors.ustc.edu.cn/mysql-repo/yum/mysql-8.0-community/el/7/x86_64/mysql-community-client-plugins-8.0.31-1.el7.x86_64.rpm

wget https://mirrors.ustc.edu.cn/mysql-repo/yum/mysql-8.0-community/el/7/x86_64/mysql-community-common-8.0.31-1.el7.x86_64.rpm

wget https://mirrors.ustc.edu.cn/mysql-repo/yum/mysql-8.0-community/el/7/x86_64/mysql-community-icu-data-files-8.0.31-1.el7.x86_64.rpm

wget https://mirrors.ustc.edu.cn/mysql-repo/yum/mysql-8.0-community/el/7/x86_64/mysql-community-libs-8.0.31-1.el7.x86_64.rpm

wget https://mirrors.ustc.edu.cn/mysql-repo/yum/mysql-8.0-community/el/7/x86_64/mysql-community-server-8.0.31-1.el7.x86_64.rpm

2.安装MySQL服务器

1.安装主包即可

yum install -y mysql-community-server-8.0.31-1.el7.x86_64.rpm

2.如果提示如下报错：
表示安装server,需要其他的依赖

解决方法：

yum install -y mysql-community*

又出现这种错误
解决方法：卸载冲突的软件包，再安装

yum remove -y mariadb-libs-5.5.60-1.el7_5.x86_64

yum install -y mysql-community*

3.启动MySQL

systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld

4.进入MySQL

首先获取密码

cat /var/log/mysqld.log | awk  '/password/ {print $NF}' 
或
awk  '/password/ {print $NF}' /var/log/mysqld.log

5.修改密码：

不重置密码不能操作

ALTER USER 'root'@'localhost' IDENTIFIED BY 'LiuDeHua@123';

配置完成