# RHEL/CentOS
yum install -y gcc gcc-c++ make cmake ncurses-devel bison openssl-devel
# Ubuntu/Debian
apt-get install -y build-essential cmake libncurses5-dev bison libssl-dev
# 1. 創建用戶/組
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
# 2. 解壓源碼
tar zxvf mysql-5.1.32.tar.gz
cd mysql-5.1.32
# 3. 配置參數(關鍵參數解析見下表)
./configure \
--prefix=/usr/local/mysql \
--with-charset=utf8 \
--with-collation=utf8_general_ci \
--with-extra-charsets=all \
--with-plugins=innobase,myisam,partition \
--with-big-tables \
--enable-thread-safe-client \
--enable-local-infile
# 4. 編譯安裝
make -j$(nproc)
make install
# 5. 初始化數據目錄
cd /usr/local/mysql
cp support-files/my-medium.cnf /etc/my.cnf
# 註釋掉 log-bin=mysql-bin(若暫不需要主從)
sed -i 's/^log-bin/#log-bin/' /etc/my.cnf
scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data
# 6. 權限設置
chown -R root:root /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql/data
# 7. 啟動腳本與服務註冊
cp support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
# 8. 環境變量
echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
source /etc/profile.d/mysql.sh
# 9. 啟動並驗證
service mysqld start
mysql -u root -e "SHOW VARIABLES LIKE 'version';"
| 參數 | 作用 | 推薦值 |
|---|---|---|
--prefix | 安裝根目錄 | /usr/local/mysql |
--with-charset | 默認字符集 | utf8 / utf8mb4 (5.5+) |
--with-collation | 默認校對規則 | utf8_general_ci |
--with-extra-charsets | 額外編譯入的字符集 | all / complex |
--with-plugins | 編譯入的存儲引擎 | innobase,myisam,partition,federated |
--with-big-tables | 支持 >4GB 表 | 開啟 |
--enable-thread-safe-client | 線程安全客戶端庫 | 開啟 |
# 登入
mysql -u root -p
# 修改 root 密碼
mysqladmin -u root -p password 'NewPass!'
# 備份全庫
mysqldump -u root -p --single-transaction --routines --triggers --all-databases > /backup/full_$(date +%F).sql
# 備份單庫
mysqldump -u root -p --single-transaction --routines --triggers mydb > /backup/mydb_$(date +%F).sql
# 還原
mysql -u root -p mydb < /backup/mydb_2024-01-01.sql
# /etc/systemd/system/mysqld.service
[Unit]
Description=MySQL Server
After=network.target
[Service]
Type=forking
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data
ExecStop=/usr/local/mysql/bin/mysqladmin shutdown
TimeoutSec=300
Restart=on-failure
[Install]
WantedBy=multi-user.target
啟用:systemctl daemon-reload && systemctl enable --now mysqld