# 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
# MySql修改配置文件忽略大小写依旧不生效的问题
由于Mysql的安全机制，权限为777的文件会被Mysql忽略，所以，配置文件修改为644即可