服務控制
sudo /etc/init.d/mysql start
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql restart
錯誤日誌查看
cat /var/log/mysql.err
cat /var/log/mysql/error.log
中文支援配置 (/etc/mysql/my.cnf)
[client]
default-character-set = utf8
[mysqld]
character_set_server = utf8
collation_server = utf8_general_ci
MySQL 5.5+ 建議使用 character_set_server 替代 default-character-set，後者在 [mysqld] 下會報 unknown variable 錯誤。
常見報錯對照
| 報錯 | 原因 | 修正 |
|---|
| unknown variable 'default-character-set=utf8' | 參數名過時 | 改為 character_set_server=utf8 |
| Can't connect to local MySQL server through socket | 服務未啟動/ socket 路徑錯 | service mysql start / 檢查 socket 參數 |
