Centos7 部署mysql-8.0.31-1.el7.x86_64

MySQL官网下载最新MySQL安装包

MySQL :: Download MySQL Community Server

 上传到Centos7并解压

tar -xvf mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar

执行以下命令时版本号要与你下载的版本号相同

安装MySQL

按顺序安装

• 必要安装（注意顺序）
• 安装common
• 安装lib 依赖于common，确保已经卸载mariadb
• 依赖于libs
• 依赖于client、common

# 必须按照顺序
rpm -ivh mysql-community-common-8.0.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.30-1.el7.x86_64.rpm
yum install net-tools -y
rpm -ivh mysql-community-icu-data-files-8.0.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.30-1.el7.x86_64.rpm
 

在执行到此命令时

rpm -ivh mysql-community-libs-8.0.30-1.el7.x86_64.rpm

会报warning: mysql-community-libs-8.0.28-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
error: Failed dependencies:
    mariadb-libs is obsoleted by mysql-community-libs-8.0.28-1.el7.x86_64

解决方法

# 先卸载mysql-libs
yum remove mysql-libs
# 再执行安装
rpm -ivh mysql-community-libs-8.0.28-1.el7.x86_64.rpm

 

安装好后 启动服务

systemctl status mysqld
systemctl enable mysqld
//
sudo service mysql status
//
sudo service mysql start

在查看初始密码

cat /var/log/mysqld.log | grep password

之后登录

mysql -uroot -p密码

再修改密码 8.0的修改命令和5.几的命令有所不同

ALTER USER 'root'@'localhost' IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY 'password';


ALTER USER '{用户名}'@'localhost' IDENTIFIED BY '{新密码}';

设置远程登录

use mysql;
update user set host = '%' where user ='root';
flush privileges;