CentOs8 安装 Mysql 8 步骤及问题解决

 1.Mysql数据库采用的版本是Mysql8

在Mysql官方网站：MySQL 下载Mysql安装包

2.安装新版mysql之前，我们需要将系统自带的mariadb-lib卸载

执行命令：rpm -qa|grep mariadb

若检查出系统自带mariadb-lib则需要先卸载

例如：输出结果为：mariadb-libs-5.5.56-2.el7.x86_64

卸载命令为：rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps

3.上传tar包至服务器并解压

下载Mysql的rpm集合包：mysql-8.0.11-1.el7.x86_64.rpm-bundle.tar

上传mysql-8.0.11-1.el7.x86_64.rpm-bundle.tar到linux服务器，并解压tar包。

tar xvf /usr/local/mysql8.tar

mysql-community-client-8.0.11-1.el7.x86_64.rpm 
mysql-community-libs-8.0.11-1.el7.x86_64.rpm 
mysql-community-server-minimal-8.0.11-1.el7.x86_64.rpm
mysql-community-common-8.0.11-1.el7.x86_64.rpm 
mysql-community-libs-compat-8.0.11-1.el7.x86_64.rpm 
mysql-community-test-8.0.11-1.el7.x86_64.rpm
mysql-community-devel-8.0.11-1.el7.x86_64.rpm 
mysql-community-minimal-debuginfo-8.0.11-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.11-1.el7.x86_64.rpm 
mysql-community-server-8.0.11-1.el7.x86_64.rpm

4.安装mysql-server服务，只需要安装如下4个软件包即可，我们可以使用rpm -ivh命令进行安装

rpm -ivh mysql-community-common-8.0.11-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.11-1.el7.x86_64.rpm --（依赖于common）

rpm -ivh mysql-community-client-8.0.11-1.el7.x86_64.rpm --（依赖于libs）

rpm -ivh mysql-community-server-8.0.11-1.el7.x86_64.rpm --（依赖于client、common）

 安装过程中可能会遇到报错：

4.1

rpm -ivh mysql-community-server-8.0.11-1.el7.x86_64.rpm
警告：mysql-community-server-8.0.11-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
错误：依赖检测失败：
libaio.so.1()(64bit) 被 mysql-community-server-8.0.11-1.el7.x86_64 需要
libaio.so.1(LIBAIO_0.1)(64bit) 被 mysql-community-server-8.0.11-1.el7.x86_64 需要
libaio.so.1(LIBAIO_0.4)(64bit) 被 mysql-community-server-8.0.11-1.el7.x86_64 需要
 

解决方法：yum install libaio

4.2

error: Failed dependencies:
libnuma.so.1()(64bit) is needed by mysql-community-server-5.7.9-1.el6.x86_64
libnuma.so.1(libnuma_1.1)(64bit) is needed by mysql-community-server-5.7.9-1.el6.x86_64
libnuma.so.1(libnuma_1.2)(64bit) is needed by mysql-community-server-5.7.9-1.el6.x86_64

解决方法：yum install numactl

4.3

解决方法：yum install libncurses*

4.4

安装server时报错
rpm -ivh mysql-community-server-8.0.21-1.el7.x86_64.rpm
警告：mysql-community-server-8.0.21-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
错误：依赖检测失败：
/usr/bin/perl 被 mysql-community-server-8.0.21-1.el7.x86_64 需要
net-tools 被 mysql-community-server-8.0.21-1.el7.x86_64 需要
perl(Getopt::Long) 被 mysql-community-server-8.0.21-1.el7.x86_64 需要
perl(strict) 被 mysql-community-server-8.0.21-1.el7.x86_64 需要

(1) 下载和无依赖安装perl

wget mirrors.aliyun.com/centos/7.9.2009/os/x86_64/Packages/perl-5.16.3-297.el7.x86_64.rpm
rpm -ivh perl-5.16.3-297.el7.x86_64.rpm  --nodeps

(2) 下载和无依赖安装perl-Getopt-Long

wget mirrors.aliyun.com/centos/7.9.2009/os/x86_64/Packages/perl-Getopt-Long-2.40-3.el7.noarch.rpm
rpm -ivh perl-Getopt-Long-2.40-3.el7.noarch.rpm   --nodeps

(3) 下载和安装net-tools

wget mirrors.aliyun.com/centos/7.9.2009/os/x86_64/Packages/net-tools-2.0-0.25.20131004git.el7.x86_64.rpm
rpm -ivh net-tools-2.0-0.25.20131004git.el7.x86_64.rpm

(4) 重新安装mysql-community-server-8.0.21-1.el7.x86_64.rpm

5.初始化mysql数据库

 sudo mysqld --initialize 

//该命令会在/var/log/mysqld.log生成随机密码

6.修改mysql数据库目录的所属用户及其所属组，然后启动mysql数据库

sudo chown mysql:mysql /var/lib/mysql -R

systemctl start mysqld.service

 7.根据第5步中的密码，更改root用户的密码，新版的mysql必须先修改root用户的密码，否则登录后是不能执行任何命令的

8.根据提示修改root用户密码

mysql_secure_installation

安装完成，接下来既可以正常操作mysql

mysql -u root -p 回车输入初始化的密码，进入mysql

9.设置开机自启动

启动MySQL服务并设置开机自启：
systemctl start mysqld.service
systemctl enable mysqld.servic

重启mysql服务
systemctl restart mysqld.service