針對初學者、測試環境、需快速部署單實例的場景,提供最精簡、無模糊地帶的安裝流程。
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.xx.tar.gztar -zxvf mysql-5.7.xx.tar.gzcd mysql-5.7.xx./configure --prefix=/usr/local/mysqlmakemake installcd scripts./mysql_install_db --user=mysqlcp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqldchmod +x /etc/init.d/mysqldservice mysqld start 或 /etc/init.d/mysqld start/usr/local/mysql/bin/mysqladmin -u root password 'NewPass!23'echo "/etc/init.d/mysqld start" >> /etc/rc.d/rc.local
chmod +x /etc/rc.d/rc.local
/usr/local/mysql/bin/mysql -u root -p
SHOW DATABASES;
-- 應見 mysql、test、information_schema、performance_schema、sys
| 錯誤 | 對策 |
|---|---|
configure: error: no acceptable C compiler | yum install gcc gcc-c++ make 或 apt install build-essential |
mysql_install_db: command not found | MySQL 5.7+ 請用 mysqld --initialize --user=mysql |
啟動失敗 Permission denied | chown -R mysql:mysql /usr/local/mysql/data |
連線報 Can't connect to local MySQL server through socket | 檢查 my.cnf socket 路徑與啟動腳本一致 |
13 步驟、不到 10 分鐘,即可在 Linux 上跑起一個可用的 MySQL 實例。生產環境請務必補充:my.cnf 調優、雙機複寫、定時備份、監控告警、權限最小化等體系化建設。