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包。
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
安装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