萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 資料庫 >> MySQL 教學

從源碼編譯安裝 MySQL 5.0/5.1 完整步驟:依賴、配置參數、初始化與系統服務註冊

編譯環境準備


# 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';"

關鍵 configure 參數對照表

參數作用推薦值
--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

systemd 服務單元(現代 Linux 推薦)


# /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

copyright © 萬盛學電腦網 all rights reserved