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 协议》,转载必须注明作者和本文链接
你这属于写标题都不会写啊,直接把报错问题写在标题上 很少人这样写文章