安装 libaio
rpm -qa|grep libaio
yum -y install libaio-devel.x86_64
下载mysql 对应的版本
MySQL :: Download MySQL Community Server (Archived Versions)
统一解压到 /usr/load 是 -xvf参数非-zxvf
tar -xvf /home/download/mysql-8.0.32-linux-glibc2.12-x86_64.tar.xz -C /usr/load
rm -rf mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz
mv mysql-8.0.16-linux-glibc2.12-x86_64 /usr/local/mysql8.0
或 tar -xvf mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz -C /path
groupadd mysql
useradd -r -g mysql mysql
chown -R mysql.mysql /usr/local/mysql8.0/
在mysql(根据实际自定义名称) 目录下创建 data 文件夹
mkdir data
./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --lower-case-table-names=1
chown -R root:root ./
chown -R mysql:mysql data
touch my-default.cnf
chmod 777 ./my-default.cnf
cp my-default.cnf /etc/my.cnf
vim /etc/my.cnf
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
init-connect='SET NAMES utf8mb4'
lower_case_table_names = 1
basedir=/usr/local/mysql8.0 #根据自己的安装目录填写
datadir=/usr/local/mysql8.0/data #根据自己的mysql数据目录填写
socket=/tmp/mysql.sock
max_connections=200 # 允许最大连接数
character-set-server=utf8mb4 # 服务端使用的字符集默认为8比特编码的latin1字符集
default-storage-engine=INNODB # 创建新表时将使用的默认存储引擎
log_bin_trust_function_creators=1
sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
cd /usr/local/mysql8.0/support-files/
cp mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
注册服务
chkconfig --add mysql
chkconfig --list mysql
/usr/local/mysql8.0/lib
export PATH=$PATH:/usr/local/mysql8.0/bin:/usr/local/mysql8.0/lib
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'pass_word';
exit
service mysql restart