記錄 CentOS 5.5 環境下從源碼編譯安裝 MySQL 5.5.37 的完整過程,含 CMake 編譯系統、ncurses 依賴解決、安裝後初始化、服務註冊、驗證連接。適用於舊版本維護或特定版本需求場景。
wget https://www.cmake.org/files/v2.8/cmake-2.8.12.2.tar.gz
tar xvf cmake-2.8.12.2.tar.gz
cd cmake-2.8.12.2
./bootstrap
make
make install
# 錯誤提示:Curses library not found. Please install ncurses-devel
wget https://invisible-island.net/datafiles/release/ncurses.tar.gz
tar xvf ncurses.tar.gz
cd ncurses-5.9
./configure
make
make install
# 1. 獲取源碼
wget https://cdn.mysql.com/Downloads/MySQL-5.5/mysql-5.5.37.tar.gz
tar xvf mysql-5.5.37.tar.gz
cd mysql-5.5.37
# 2. CMake 配置(刪除舊 CMakeCache.txt 重新配置)
rm -f CMakeCache.txt
cmake .
# 3. 編譯安裝
make -j$(nproc)
make install
# 默認安裝至 /usr/local/mysql
groupadd mysql
useradd -r -g mysql mysql
chown -R mysql:mysql /usr/local/mysql
/usr/local/mysql/scripts/mysql_install_db \
--user=mysql \
--basedir=/usr/local/mysql \
--datadir=/usr/local/mysql/data
⚠️ 若啟動報 FATAL ERROR: Could not find ./bin/my_print_defaults,必須執行此步驟並指定 --basedir。
/usr/local/mysql/bin/mysqld_safe --user=mysql &
# 複製配置文件
cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf
# 複製啟動腳本
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
# 添加到 chkconfig
/sbin/chkconfig --add mysql
/sbin/chkconfig mysql on
service mysql start
service mysql status
service mysql stop
/usr/local/mysql/bin/mysql -u root -p
# 輸入密碼(初始為空)
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
| 錯誤 | 原因 | 解決 |
|---|---|---|
| Curses library not found | 缺 ncurses-devel | 源碼安裝 ncurses 或 yum install ncurses-devel |
| Could not find my_print_defaults | 未執行 mysql_install_db 或 basedir 錯誤 | 執行 mysql_install_db --basedir=... |
| Can't create test file | datadir 權限/SELinux | chown mysql:mysql /datadir; setenforce 0 |
| InnoDB: Operating system error number 13 | 目錄權限/SELinux | 同上 |
my-large.cnf 根據記憶體調整 innodb_buffer_pool_size 等mysql_secure_installation 設置 root 密碼、移除匿名用戶、禁止遠程 root、移除 test 庫xtrabackup 物理熱備 + Binlog 增量MySQL 5.5 已停止維護(EOL 2018-12)。新部署請使用 MySQL 8.0 LTS 或 MariaDB 10.6+,獲得:
源碼編譯安裝 MySQL 5.5 核心流程:CMake → ncurses → cmake . → make → make install → mysql_install_db → 服務註冊 → 安全初始化。關鍵坑點在 CMakeCache.txt 殘留導致重新配置失效、mysql_install_db 必須指定 basedir。現代部署強烈建議使用包管理器(yum/dnf/apt)或官方二進制包/容器鏡像,減少編譯維護負擔。