别再yum装MySQL了！教你大厂级部署法部署MySQL8.4，实测无坑，可无脑照抄

[root@vbox ~]# setenforce  0 

[root@vbox ~]# systemctl status   firewalld
firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
   Active: active (running) since Wed 2026-01-14 04:13:01 EST; 21s ago
     Docs: man:firewalld(1)
 Main PID: 13831 (firewalld)
   CGroup: /system.slice/firewalld.service
           └─13831 /usr/bin/python2 -Es /usr/sbin/firewalld --nofork --nopid
Jan 14 04:13:01 vbox systemd[1]: Starting firewalld - dynamic firewall daemon...
Jan 14 04:13:01 vbox systemd[1]: Started firewalld - dynamic firewall daemon.
Jan 14 04:13:01 vbox firewalld[13831]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be removed in a future release. Please consider disabling it now.
[root@vbox ~]# systemctl stop   firewalld
[root@vbox ~]# systemctl disable  firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.

mysql soft nofile 65536
mysql hard nofile 65536
mysql soft nproc 65536
mysql hard nproc 65536

echo never > /sys/kernel/mm/transparent_hugepage/enabled
echo never > /sys/kernel/mm/transparent_hugepage/defrag  
# 同时关闭碎片整理功能

if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
    echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag; then
    echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi

# /etc/sysctl.conf
vm.swappiness = 1
net.core.somaxconn = 65535
fs.file-max = 2097152

yum install libaio numactl-libs  -y

# 创建 mysql 用户（禁止登录）
 useradd -r -s /sbin/nologin mysql

[root@vbox ~]# cat /etc/redhat-release 
CentOS Linux release 7.9.2009 (Core)
[root@vbox ~]# ldd --version
ldd (GNU libc) 2.17
Copyright (C) 2012 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
Written by Roland McGrath and Ulrich Drepper.

[root@vbox local]# xz -d mysql-8.4.7-linux-glibc2.17-x86_64.tar.xz 
[root@vbox local]# ll -h
total 1.5G
drwxr-xr-x. 2 root root    6 Apr 11  2018 bin
drwxr-xr-x. 2 root root    6 Apr 11  2018 etc
drwxr-xr-x. 2 root root    6 Apr 11  2018 games
drwxr-xr-x. 2 root root    6 Apr 11  2018 include
drwxr-xr-x. 2 root root    6 Apr 11  2018 lib
drwxr-xr-x. 2 root root    6 Apr 11  2018 lib64
drwxr-xr-x. 2 root root    6 Apr 11  2018 libexec
-rw-r--r--. 1 root root 1.5G Jan 14 06:15 mysql-8.4.7-linux-glibc2.17-x86_64.tar
drwxr-xr-x. 2 root root    6 Apr 11  2018 sbin
drwxr-xr-x. 5 root root   49 Jan 13 20:19 share
drwxr-xr-x. 2 root root    6 Apr 11  2018 src
[root@vbox local]# tar -xvf mysql-8.4.7-linux-glibc2.17-x86_64.tar 
mysql-8.4.7-linux-glibc2.17-x86_64/bin/
mysql-8.4.7-linux-glibc2.17-x86_64/bin/myisam_ftdump
mysql-8.4.7-linux-glibc2.17-x86_64/bin/myisamchk

ln -s mysql-8.4.7-linux-glibc2.17-x86_64 mysql8.4
 cd mysql8.4
chown -R mysql:root .

# 创建目录
mkdir -p /data/mysql/mysql3306/{data,logs,etc,tmp}
# 修改属主
chown -R  mysql:mysql  /data/mysql/mysql3306/

cd /usr/local/mysql8.4/
bin/mysqld --defaults-file=/data/mysql/mysql3306/etc/my.cnf  --initialize --user=mysql

grep "temporary password" /data/mysql/mysql3306/logs/mysqld.log 
2026-01-14T19:38:18.113660Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: <E,-q/dBL6-p

[root@vbox mysql8.4]# /usr/local/mysql8.4/bin/mysqld_safe  --defaults-file=/data/mysql/mysql3306/etc/my.cnf   &
[1] 14967
[root@vbox mysql8.4]# 2026-01-14T11:47:36.972672Z mysqld_safe Logging to '/data/mysql/mysql3306/logs/mysqld.log'.
2026-01-14T11:47:37.051154Z mysqld_safe Starting mysqld daemon with databases from /data/mysql/mysql3306/data
[root@vbox mysql8.4]# /usr/local/mysql8.4/bin/mysql -uroot -p'<E,-q/dBL6-p' --socket=/data/mysql/mysql3306/tmp/mysql.sock -A 
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.4.7
Copyright (c) 2000, 2025, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> alter user root@'localhost' identified by 'Strong.Password2026!';
Query OK, 0 rows affected (0.02 sec)

-- 可选：创建应用用户
CREATE USER 'appuser'@'%' IDENTIFIED BY 'AppPass!2026';
GRANT SELECT, INSERT, UPDATE, DELETE ON mydb.* TO 'appuser'@'%';
FLUSH PRIVILEGES;
EXIT;

export MYSQL_HOME=/usr/local/mysql8.4
export PATH=$MYSQL_HOME/bin:$PATH
export LD_LIBRARY_PATH=/usr/local/mysql8.4/lib:$LD_LIBRARY_PATH

[Unit]
Description=MySQL Server
After=network.target
After=syslog.target
[Service]
User=mysql
Group=mysql
Type=notify
ExecStart=/usr/local/mysql8.4/bin/mysqld  --defaults-file=/data/mysql/mysql3306/etc/my.cnf
TimeoutSec=300
Restart=on-failure
RestartPreventExitStatus=1
PrivateTmp=false
[Install]
WantedBy=multi-user.target

systemctl daemon-reload
systemctl enable mysqld

systemctl  start   mysqld
systemctl  status   mysqld