1.切换系统目录/opt
l cd /opt
2.下载安装包
l wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz
3.解压安装包
l tar xvJf mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz
4.将解压后文件移动到/usr/local下并重命名为mysql
l mv /opt/mysql-8.0.20-linux-glibc2.12-x86_64 /usr/local/mysql
5.在/usr/local/mysql目录下创建data文件路径用来存放数据文件
l mkdir -p /usr/local/mysql/data
6.创建mysql用户和用户组
l groupadd mysql
l useradd -g mysql mysql
7.给mysql安装目录和数据目录授权mysql用户
l chown -R mysql:mysql /usr/local/mysql/
l chmod 775 -R /usr/local/mysql/data
8.配置环境,编辑/etc/profile文件添加如下内容
l export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib
9.编辑(创建)/etc/my.cnf内容如下
[mysql]
default-character-set=utf8mb4
[client]
socket=/var/lib/mysql/mysql.sock
[mysqld]
user=mysql
general_log = 1
general_log_file= /var/log/mysql/mysql.log
socket=/var/lib/mysql/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
log-bin=/usr/local/mysql/data/mysql-bin
innodb_data_home_dir=/usr/local/mysql/data
innodb_log_group_home_dir=/usr/local/mysql/data/
character-set-server=utf8mb4
lower_case_table_names=1
autocommit=1
default_authentication_plugin=mysql_native_password
symbolic-links=0
[mysqld_safe]
log-error=/usr/local/mysql/data/mysql.log
pid-file=/usr/local/mysql/data/mysql.pid
10.切换到/usr/local/mysql/bin目录下执行mysql初始化
l cd /usr/local/mysql/bin
l ./mysqld –user=mysql –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data/ –initialize
11.初始化报错如下图

需要安装libaio包
yum install -y libaio
执行初始化后如下图,图上红色标记框为数据库默认密码。

12.将mysql.server文件放到启动/etc/init.d/目录中
l cp -a /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
l cp -a /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
13.检查一下/var/lib/mysql是否存在,没有就创建一个
l mkdir /var/lib/mysql
14.相关文件赋权
l chown 777 /etc/my.cnf
l chmod +x /etc/init.d/mysql
l chmod +x /etc/init.d/mysqld
l chown -R mysql:mysql /var/lib/mysql/
15.创建mysql命令链接
l ln -s /usr/local/mysql/bin/mysql /usr/bin
16.启动MySQL服务
l service mysql start
17.登录MySQL数据库
l mysql -u root -p

18.修改初始化密码和数据库连接权限
l ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘输入新密码’;
l use mysql;
l update user set host=’%’ where user=’root’;
l flush privileges;
完结