一.环境

• 平台：centos7.9.2009 (Core)
• 软件：MySQL5.7.33

二. 部署过程

• 说明
  下载软件地址：/usr/local
  解压地址：/usr/local/mysql
  安装地址：/data/3306/data
  配置地址：/data/3306
• 下载地址

https://dev.mysql.com/downloads/file/?id=500591

• 环境配置

groupadd mysql
useradd -g mysql -m mysql 

• 解压

 tar -zxf mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.33-linux-glibc2.12-x86_64 /usr/local/mysql && chown -R mysql.mysql /usr/local/mysql

• 修改环境变量并应用
  vim /root/.bash_profile

export PATH=$PATH:/usr/local/mysql/bin

source /root/.bash_profile

• 生成配置&赋予权限
  mkdir -p /data/3306/data
  vim /data/3306/my.cnf

[mysqld]
user=mysql
datadir=/data/3306/data
basedir=/usr/local/mysql
port=3306
socket=/data/3306/mysql.sock
server_id=1
gtid_mode=ON
enforce_gtid_consistency=ON
master_info_repository=TABLE
relay_log_info_repository=TABLE
binlog_checksum=NONE
log_slave_updates=ON
log_bin=binlog
binlog_format=ROW

chown -R mysql.mysql /data/3306
chown -R mysql.mysql /usr/local/mysql

• 初始化并启动

/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/3306/data

进入mysql用户模式：
su - mysql
mysqld_safe --defaults-file=/data/3306/my.cnf &

• 登录&修改密码

/usr/local/mysql/bin/mysql -s /data/3306/mysql.sock
grant all on *.* to root@'%' identified by '123456m' with grant option;flush privileges;
-- 或者：set password for root@'localhost' = password("123456m");

• 关闭数据库
  mysqladmin shutdown -S /data/3306/mysql.sock -uroot -p123456m

• 配置systemctl启动

su - root

vim /etc/systemd/system/mysqld3306.service

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/data/3306/my.cnf
LimitNOFILE = 5000

启动：systemctl start mysqld3306
关闭：systemctl stop mysqld3306
状态：systemctl status mysqld3306
重启：systemctl restart mysqld3306