# MySQL 无法启动（掉电）Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 2991577 an
2019-10-23T16:23:45.042843+08:00 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 2991577 and the end 2991104.
2019-10-23T16:23:45.044711+08:00 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-10-23T16:23:45.488032+08:00 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-10-23T16:23:45.496762+08:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-10-23T16:23:45.497341+08:00 0 [ERROR] Failed to initialize builtin plugins.
2019-10-23T16:23:45.497401+08:00 0 [ERROR] Aborting
删除/var/lib/mysql目录下的ib_logfile0和ib_logfile1重新启动就可以了
# message from server: "Host 'DESKTOP-QIR7OV5' is not allowed to connect to this MySQL server"
打开Navicat看到里面有个mysql数据库，库里有张user表
修改user表中的字段"Host"为"%"
然后右键点击目标数据库，选择刷新->权限
# ERROR 2006 (HY000): MySQL server has gone away
因为单条数据过大导致，修改允许的大小即可
show global variables like 'max_allowed_packet';
[mysqld]
max_allowed_packet=1024M