mysql8.0 安装教程，亲测

yum install -y libaio.x86_64 glibc.i686
# 下载mysql8.0
wget https://cdn.mysql.com/archives/mysql-8.0/mysql-8.0.22-el7-x86_64.tar.gz
# 解压到/usr/local/
tar -zxvf mysql-8.0.22-el7-x86_64.tar.gz -C /usr/local/ 
cd /usr/local/ 
# 重命名为mysql
mv mysql-8.0.22-el7-x86_64 mysql
cd mysql
# 删除data文件夹
rm -rf data
# 新建data文件夹
mkdir data

# 为系统新建mysql用户组
groupadd mysql
# 为系统新建mysql用户
useradd -g mysql mysql

# 修改mysql文件夹用户权限
chown -R mysql.mysql /usr/local/mysql/
# 初始化mysql 并且记录临时密码
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
# 新建mysql配置文件
vim /etc/my.cnf 

[client]
port=3306
socket=/tmp/mysql.sock

[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
socket=/tmp/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

# 添加mysql启动脚本，到服务目录
cp -a ./support-files/mysql.server /etc/init.d/mysqld
# 添加可执行权限
chmod +x /etc/rc.d/init.d/mysqld
# 将mysql添加到系统服务   
chkconfig --add mysqld
# 启动服务mysql
service mysql start
# 这里遇到了坑，安装mysql8.0 之前我还安装了mariadb，直接输入mysql，系统运行的是mariadb的mysql客户端，
# 导致无法正确连接到mysql8.0，这里直接绝对路径启动mysql客户端
/usr/local/mysql/bin/mysql -uroot -p
# 输入刚刚得到的临时密码

# 首次登陆mysql8.0 必须更改密码
set password for root@localhost = '123';
# 切换到mysql数据库
use mysql
update user set host = '%' where user = 'root' and host='localhost';
flush privileges;
# 允许任意主机连接
GRANT ALL PRIVILEGES ON root TO 'root'@'%';
# 上面指令的操作只是更新了硬盘的数据，需要flush到内存。
flush privileges;  
# 修改密码验证方式为mysql_native_password，否则远程无法登陆
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123';
flush privileges;