安装

sudo groupadd mysql
sudo useradd -r -g mysql -s /bin/false mysql

sudo tar -xvf mysql-8.4.7-linux-glibc2.28-x86_64.tar.xz -C /usr/local/

ln -s /usr/local/mysql-8.4.7-linux-glibc2.28-x86_64  mysql

sudo vim /etc/profile

vim /etc/profile 添加

MYSQL_HOME=/usr/local/mysql
export PATH=${MYSQL_HOME}/bin:${PATH}

source /etc/profile

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

cd /usr/local/mysql

sudo bin/mysqld --initialize --user=mysql

#后台启动MySQL
sudo bin/mysqld_safe --user=mysql &
#查看MySQL启动进程
ps -ef | grep mysql

source /etc/profile
#修改MySQL密码
alter user 'root'@'localhost' identified by '123456';
FLUSH PRIVILEGES;

配置启动文件

cd /usr/local/mysql
sudo cp support-files/mysql.server /etc/init.d/mysql

启动管理

#重启
sudo service mysql restart

#开启
sudo service mysql start

#关闭
sudo service mysql stop

#设置开机自启，不推荐，因为启动的还是 /etc/init.d/mysql
sudo systemctl enable mysql.service 

设置开机自启

sudo mkdir -p /var/log/mysql
sudo chown mysql:mysql /var/log/mysql

sudo vim /etc/my.cnf

vim /etc/my.cnf

[mysqld]
datadir = /usr/local/mysql/data
socket = /tmp/mysql.sock
 
log-error = /var/log/mysql/mysqld.log
 
basedir = /usr/local/mysql

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

vim /etc/systemd/system/mysql.service

[Unit]
Description=MySQL Server
After=network.target
 
[Service]
Type=notify
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
Restart=always
RestartSec=5
TimeoutSec=300
StandardOutput=null
StandardError=journal
LimitNOFILE=65536
 
# 安全加固（可选）
PrivateTmp=false
ProtectHome=true
NoNewPrivileges=true
 
[Install]
WantedBy=multi-user.target

sudo systemctl daemon-reload
sudo systemctl enable mysql.service 
sudo systemctl restart mysql.service