# CentOS 7 / RHEL 7
yum install -y gcc gcc-c++ ncurses-devel perl cmake3
# Ubuntu / Debian
apt-get update && apt-get install -y g++ libncurses5-dev perl cmake
MySQL 5.7 依賴 Boost,官方提供捆綁包避免版本匹配麻煩:
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.XX.tar.gz
tar xzf mysql-boost-5.7.XX.tar.gz
cd mysql-5.7.XX
cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DMYSQL_DATADIR=/var/lib/mysql \
-DMYSQL_TCP_PORT=3306 \
-DWITH_BOOST=boost \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_SSL=system \
-DWITH_ZLIB=system \
-DWITH_DEBUG=0
參數詳見官網:Source Configuration Options
# 多核並行編譯
make -j$(nproc) && make install
CMakeFiles/CMakeError.log。groupadd mysql
useradd -r -g mysql mysql
mkdir -p /var/lib/mysql
chown -R mysql:mysql /var/lib/mysql /usr/local/mysql
cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
# 編輯 /etc/my.cnf 根據實際調整 buffer_pool 等參數
/usr/local/mysql/bin/mysqld --initialize --user=mysql
# 輸出類似:[Note] A temporary password is generated for root@localhost: xYz#123AbC
密碼也記錄在 /root/.mysql_secret。
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
systemctl start mysqld
/usr/local/mysql/bin/mysql -uroot -p'xYz#123AbC'
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewStrongPass123!';
mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'NewStrongPass123!';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
echo 'export PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile
source /etc/profile
mysql -V
# mysql Ver 14.14 Distrib 5.7.XX, for Linux (x86_64)
mysqladmin -uroot -p version
# Uptime、Threads、Questions 正常即成功
| 錯誤 | 原因 | 解決 |
|---|---|---|
| CMake Error: Could NOT find Curses | 缺 ncurses-devel | yum install ncurses-devel |
| Boost not found | 未指定 -DWITH_BOOST | 使用 mysql-boost 包或 -DWITH_BOOST=/path/to/boost |
| make 失敗: undefined reference | GCC 版本過舊/過新 | 安裝 devtoolset-7/8 (CentOS 7) |
| 初始化失敗: data directory not empty | /var/lib/mysql 有殘留 | mv /var/lib/mysql /var/lib/mysql.bak |