# 編譯 (根據(jù) CPU 核數(shù)調(diào)整 -j 后面的數(shù)字，例如 4 核就用 -j 4)
make -j $(nproc)
# 安裝
make install

echo 'export PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile
source /etc/profile

[mysqld]
basedir = /usr/local/mysql
datadir = /data/mysql
port = 3306
socket = /tmp/mysql.sock
pid-file = /data/mysql/mysqld.pid
user = mysql
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
skip-name-resolve
sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[client]
socket = /tmp/mysql.sock
default-character-set = utf8mb4

# 確保數(shù)據(jù)目錄權(quán)限正確
chown -R mysql:mysql /data/mysql
chown -R mysql:mysql /usr/local/mysql
# 初始化 (不安全模式，root 無(wú)密碼)
/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql
# 如果要用安全模式（生成臨時(shí)密碼），請(qǐng)看日志末尾
# /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
# 啟動(dòng)
/etc/init.d/mysqld start
# 設(shè)置開(kāi)機(jī)自啟
chkconfig --add mysqld
chkconfig mysqld on

[Unit]
Description=MySQL Server
After=network.target
[Service]
Type=forking
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
ExecReload=/bin/kill -HUP $MAINPID
KillMode=process
Restart=on-failure
LimitNOFILE=65535
[Install]
WantedBy=multi-user.target

systemctl daemon-reload
systemctl start mysqld
systemctl enable mysqld

mysql -u root

grep 'temporary password' /data/mysql/error.log
mysql -u root -p
# 輸入上面查到的臨時(shí)密碼

-- 修改 root 密碼
ALTER USER 'root'@'localhost' IDENTIFIED BY 'YourStrongPassword123!';
-- 允許遠(yuǎn)程連接 (可選)
CREATE USER 'root'@'%' IDENTIFIED BY 'YourStrongPassword123!';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
-- 退出
EXIT;

mysql -V
# 輸出應(yīng)包含 "Ver 8.0.xx"
netstat -tlnp | grep 3306
# 確認(rèn)端口監(jiān)聽(tīng)