[运维] mysql使用笔记（持续更新）

常用操作

1. 查看错误日志

cat /var/log/mysql/error.log

2. 查看配置文件

ls /etc/mysql/

常见错误处理

1. 报以下错误信息

[ERROR] InnoDB: Missing MLOG_CHECKPOINT at 14368196 between the checkpoint 14368196 and the end 14367744.
[ERROR] InnoDB: Plugin initialization aborted with error Generic error
[Note] InnoDB: Starting shutdown...
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[Note] Plugin 'FEEDBACK' is disabled.
[ERROR] Unknown/unsupported storage engine: InnoDB
[ERROR] Aborting

处理方案：见CentOS下的MySQL爬坑（Plugin ‘InnoDB’ init function returned error.）