虽然公司用的是5.6左右版本的mysql，但是还是想用下最新版本的，看看区别
1、先安装下wget命令
[root@rhino001 rhino]# yum -y install wget
2、从阿里云镜像服务器上下载mysql8.0
[rhino@rhino001 ~]$ wget mirrors.aliyun.com/mysql/MySQL-8.0/mysql-8.0.21-1.el7.x86_64.rpm-bundle.tar
3、解压mysql安装包
[rhino@rhino001 ~]$ tar -xvf mysql-8.0.21-1.el7.x86_64.rpm-bundle.tar
得到很多的rpm
4、安装服务（仅安装必要插件）
[root@rhino001 rhino]# rpm -ivh mysql-community-common-8.0.21-1.el7.x86_64.rpm
[root@rhino001 rhino]# rpm -ivh mysql-community-libs-8.0.21-1.el7.x86_64.rpm
[root@rhino001 rhino]# rpm -ivh mysql-community-client-8.0.21-1.el7.x86_64.rpm
[root@rhino001 rhino]# rpm -ivh mysql-community-server-8.0.21-1.el7.x86_64.rpm
5、初始化数据库
[root@rhino001 rhino]# mysqld --initialize --console
6、给mysql用户授权（之前安装时已创建了MySQL用户）
[root@rhino001 rhino]# chown -R mysql:mysql /var/lib/mysql/
7、启动mysql
[root@rhino001 rhino]# systemctl start mysqld
[root@rhino001 rhino]# systemctl status mysqld
8、查看临时密码
[root@rhino001 rhino]# cat /var/log/mysqld.log
2021-01-24T17:49:53.386604Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: nRPT=tFgS2ki
则临时密码为nRPT=tFgS2ki，账号为root
登陆
[root@rhino001 rhino]# mysql -u root -p
9、修改密码(必须包含：数字大小写字母特殊字符)、加密规则（为了兼容native）、远程连接ip
mysql> use mysql;
mysql> select host, user, authentication_string, plugin from user;
mysql> alter USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Root@123';
mysql> flush privileges;
mysql> update user set host = "%" where user='root';
mysql> flush privileges;
10、使用native登陆
11、mysql服务关闭
[root@rhino001 rhino]# service mysqld stop
FAQ
1、安装libs时报错
[root@rhino001 rhino]# rpm -ivh mysql-community-libs-8.0.21-1.el7.x86_64.rpm
警告：mysql-community-libs-8.0.21-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
错误：依赖检测失败：
mariadb-libs 被 mysql-community-libs-8.0.21-1.el7.x86_64 取代
解决方案：移除之前的mysql的libs
[root@rhino001 rhino]# yum remove mysql-libs
重新安装mysql-community-libs-8.0.21-1.el7.x86_64.rpm
2、安装server时报错
[root@rhino001 rhino]# 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
[root@rhino001 rhino]# wget mirrors.aliyun.com/centos/7.9.2009/os/x86_64/Packages/perl-5.16.3-297.el7.x86_64.rpm
[root@rhino001 rhino]# rpm -ivh perl-5.16.3-297.el7.x86_64.rpm --nodeps
(2) 下载和无依赖安装perl-Getopt-Long
[root@rhino001 rhino]# wget mirrors.aliyun.com/centos/7.9.2009/os/x86_64/Packages/perl-Getopt-Long-2.40-3.el7.noarch.rpm
[root@rhino001 rhino]# rpm -ivh perl-Getopt-Long-2.40-3.el7.noarch.rpm --nodeps
(3) 下载和安装net-tools
[root@rhino001 rhino]# wget mirrors.aliyun.com/centos/7.9.2009/os/x86_64/Packages/net-tools-2.0-0.25.20131004git.el7.x86_64.rpm
[root@rhino001 rhino]# 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
参考链接：https://blog.csdn.net/qq_23167527/article/details/85236999
非常感谢这篇文章和作者提供的帮助与支持！
