> 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