Centos 7.9 安装 MySQL 8.0.32的详细教程

xz -dv mysql-8.0.32-linux-glibc2.12-x86_64.tar.xz
tar -xvf mysql-8.0.32-linux-glibc2.12-x86_64.tar

sudo cp -r mysql-8.0.32-linux-glibc2.12-x86_64/* /usr/local/mysql

sudo groupadd mysql
sudo useradd mysql -s /usr/sbin/nologin -g mysql

chown -R mysql:mysql /usr/local/mysql/

[client]
port=3306
# 端口
# mysqlx_port=33060
Socket=/var/lib/mysql/mysql.sock
# mysqlx_socket=/var/lib/mysqlx.sock

[mysqld]
# skip-grant-tables
# mysql安装目录
basedir=/usr/local/mysql/
# mysql数据库目录
datadir=/var/lib/mysql/data/
port=3306
innodb_file_per_table=1
character-set-server=UTF8MB4
mysqlx_port=33060
socket = /var/lib/mysql/mysql.sock
# mysqlx_socket=/var/lib/mysql/mysqlx.sock

[mysqld_safe]
# 错误日志
log-error=/var/log/mysql/error.log
# pid文件
pid-file=/usr/local/mysql/mysqld.pid
tmpdir=/var/lib/mysql/mysql

sudo ./bin/mysqld --defaults-file=/etc/my.cnf --user=mysql --initialize

sudo ./bin/mysqld --defaults-file=/etc/my.cnf --user=mysql

ALTER USER 'root'@'localhost' IDENTIFIED BY '你的密码';

sudo vim /etc/systemd/system/mysql.service

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
After=network.target
After=syslog.target

[Install]
WantedBy=multi-user.target

[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
#Restart=on-failure
#RestartPreventExitStatus=1
#PrivateTmp=false

# 使能
sudo systemctl enable mysql.service
# 启动
sudo systemctl start mysql.service
# 查看状态
sudo systemctl status mysql.service