MySQL The server quit without updating PID file xx/var/DESKTOP-BHVUG0D.pid

> Ubuntu MySQL 啟動報錯The server quit without updating PID file (/usr/local/mysql/var/DESKTOP-BHVUG0D.pid ）

MySQL 日誌錯誤 檔案位置/usr/local/mysql/var/DESKTOP-BHVUG0D.pid

2021-05-28T03:11:49.252088Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 55 = ['cai_niao/orders.ibd', 'zyy_daxue_recrit/may_menu_shortcuts.ibd']

2021-05-28T03:11:49.252147Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 57 = ['cai_niao/pick_up_codes.ibd', 'zyy_daxue_recrit/may_role_permissions.ibd']

如果有Tablespace ID: 55這種錯誤把

1、cai_niao 資料庫下的orders.ibd這張表刪除
2、zyy_daxue_recrit 資料庫下的may_menu_shortcuts.ibd這張表刪除

然後啟動MySQL

 /etc/init.d/mysql start

本作品採用《CC 協議》，轉載必須註明作者和本文連結