/var/lib/mysql 資料目錄與 /etc/my.cnf 設定檔。yum install -y autoconf automake zlib libxml ncurses-devel libgcrypt libtool openssl cmake
service mysql stoptar xf mysql-5.5.36.tar.gz
cd mysql-5.5.36
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DSYSCONFDIR=/etc \
-DMYSQL_DATADIR=/usr/local/mysql/var \
-DMYSQL_TCP_PORT=3306 \
-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock \
-DMYSQL_USER=mysql \
-DEXTRA_CHARSETS=all \
-DWITH_READLINE=1 \
-DWITH_SSL=system \
-DWITH_EMBEDDED_SERVER=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1
make && make install
rm -rf /etc/my.cnfcp support-files/my-huge.cnf /etc/my.cnfservice mysql start/usr/local/mysql/bin/mysql_upgrade
若報錯 Got error: 1064 ... FOR UPGRADE,通常是舊版有 root 密碼導致。解決方式:
# 以跳過權限表方式啟動
/usr/local/mysql/bin/mysqld --datadir=/usr/local/mysql/var --user=mysql --skip-grant-tables &
# 稍等片刻後關閉
mysqladmin shutdown
# 修正 my.cnf 參數後正常啟動
service mysql start
# 再次執行升級
/usr/local/mysql/bin/mysql_upgrade -uroot -p
cat /usr/local/mysql/mysql_upgrade_info
# 輸出應顯示 5.5.36