前置準備：移除系統預裝 MySQL
yum remove mysql
CMake 編譯安裝過程
1. 下載與解壓
cd /usr/local/src
tar xzvf cmake-2.8.4.tar.gz
cd cmake-2.8.4
2. 依賴缺失與解決（關鍵踩坑點）
| 錯誤訊息 | 缺少套件 | 解決指令 |
|---|
| Cannot find appropriate C compiler | gcc | yum install gcc |
| Cannot find appropriate C++ compiler | gcc-c++ | yum install gcc-c++ |
| Curses library not found | ncurses-devel | yum install ncurses-devel |
| Bison executable not found | bison | yum install bison |
3. 成功編譯安裝 CMake
./bootstrap
gmake
gmake install
MySQL 5.5 編譯安裝
1. 建立使用者與下載源碼
groupadd mysql
useradd -g mysql mysql
cd /usr/local/src
tar xzvf mysql-5.5.11.tar.gz
cd mysql-5.5.11
2. CMake 配置（解決依賴後）
cmake .
# 若報錯執行：
rm CMakeCache.txt
yum install ncurses-devel bison
cmake .
3. 編譯安裝（需較久時間）
make && make install
4. 後續配置
cd /usr/local/mysql
chown -R root .
chown -R mysql data
chgrp -R mysql .
scripts/mysql_install_db --user=mysql
# 安全啟動
./bin/mysqld_safe --user=mysql &
# 關閉
./bin/mysqladmin -u root shutdown -p
# 建立軟連結
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
5. 設定 root 密碼（三種方法）
# 方法一：SET PASSWORD
mysql -u root
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
# 方法二：mysqladmin
mysqladmin -u root password "newpwd"
# 方法三：UPDATE
mysql -u root
UPDATE mysql.user SET Password = PASSWORD('newpwd') WHERE User = 'root';
FLUSH PRIVILEGES;
6. 系統服務配置
cp support-files/my-medium.cnf /etc/mysql.cnf
cp support-files/mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
chkconfig --add mysqld
chkconfig mysqld on
service mysql start
service mysql shutdown
