| 錯誤碼 | 訊息 | 原因與對策 |
|---|---|---|
| 1044 | Access denied for user | 權限不足 → 檢查 GRANT 權限、FLUSH PRIVILEGES |
| 1045 | Access denied (password) | 帳號/密碼/主機錯誤 → 確認連線字串、用戶主機限制 (%) |
| 2002 | Can't connect to local MySQL server | Socket/連接埠錯誤 → 檢查 my.cnf socket 路徑、port 3306、防火牆 |
| 2003 | Can't connect to MySQL server on 'host' | 遠端連線失敗 → bind-address=0.0.0.0、授權 'user'@'%'、防火牆開 3306 |
| 1040 | Too many connections | 連線數達上限 → 調大 max_connections、檢查連線洩漏、啟用連線池 |
| 1203 | User already has more than 'max_user_connections' | 單用戶連線上限 → 調整 max_user_connections 或拆分用戶 |
| 錯誤碼 | 訊息 | 原因與對策 |
|---|---|---|
| 1005 | Can't create table (errno: 150) | 外鍵建立失敗 → 父表引擎/字符集/欄位型別/索引不匹配 |
| 1007 | Can't create database; database exists | 資料庫已存在 → IF NOT EXISTS 或先 DROP |
| 1008 | Can't drop database; database doesn't exist | 資料庫不存在 |
| 1050 | Table already exists | 建表前檢查或用 CREATE TABLE IF NOT EXISTS |
| 1051 | Unknown table | 拼寫錯誤、大小寫敏感 (Linux)、Schema 不對 |
| 1054 | Unknown column | 欄位不存在 → ALTER TABLE ADD COLUMN 或檢查拼寫 |
| 1146 | Table doesn't exist | 同 1051,常見於備份還原遺漏、Replication 同步延遲 |
| 錯誤碼 | 訊息 | 原因與對策 |
|---|---|---|
| 1022 | Duplicate key | 唯一鍵/主鍵衝突 → INSERT IGNORE / ON DUPLICATE KEY UPDATE |
| 1048 | Column cannot be null | NOT NULL 欄位未給值 → 給預設值或應用層驗證 |
| 1062 | Duplicate entry for key | 同 1022 |
| 1169 | Can't write; duplicate key in table | UPDATE 導致唯一鍵衝突 |
| 1216 | Cannot add or update child row: FK fails | 子表外鍵值在父表不存在 → 先插父表或暫時關閉 FK 檢查 |
| 1217 | Cannot delete or update parent row: FK fails | 父表被子表引用 → 先刪子表或 ON DELETE CASCADE |
| 錯誤碼 | 訊息 | 原因與對策 |
|---|---|---|
| 1021 | Disk full | 磁碟空間不足 → 清理、擴容、啟用 innodb_file_per_table |
| 1037 | Out of memory | 記憶體不足 → 調整 innodb_buffer_pool_size、排序緩衝、重啟服務 |
| 1038 | Out of sort memory | 排序緩衝不足 → 增大 sort_buffer_size |
| 1114 | Table is full | MyISAM 達 4GB/2GB 上限或磁碟滿 → 轉 InnoDB、分區、清理 |
| 1116 | Too many open tables | table_open_cache 過小 → 調大 |
| 1205 | Lock wait timeout exceeded | 鎖等待超時 → innodb_lock_wait_timeout、優化長交易、索引 |
| 1226 | User has exceeded 'max_questions' resource | 用戶資源配額用盡 → 調整 max_questions/max_updates 或重置 FLUSH USER_RESOURCES |
| 錯誤碼 | 訊息 | 原因與對策 |
|---|---|---|
| 1081 | Can't create socket | 系統插槽耗盡 → 調整 OS 參數、檢查 TIME_WAIT 連線堆積 |
| 1158-1161 | Network read/write error/timeout | 網路不穩 → 檢查交換機、MTU、keepalive、連線池重試邏輯 |
SHOW ENGINE INNODB STATUS、錯誤日誌 /var/log/mysql/error.log。SHOW GLOBAL STATUS LIKE 'Threads_%'、df -h、free -m。