查看MySQL的错误日志可以帮助我们了解MySQL在运行过程中所发生的错误,便于我们及时发现问题并解决.以下是查看MySQL错误日志的方法：
查看MySQL的配置文件
sudo vim /etc/mysql/my.cnf
查看MySQL的错误日志文件
sudo tail -f /var/log/mysql/error.log
该命令可以实时查看MySQL错误日志文件的最新内容,方便我们快速发现问题.
示例1：
# sudo tail -f /var/log/mysql/error.log
2021-07-10T09:34:12.836398Z 0 [Note] InnoDB: Starting shutdown...
2021-07-10T09:34:1③938278Z 0 [Note] InnoDB: Shutdown completed; log sequence number 16220212098;
2021-07-10T09:34:1③940170Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-10T09:34:1③940190Z 0 [Note] Shutting down plugin 'MEMORY'
2021-07-10T09:34:1③940212Z 0 [Note] Shutting down plugin 'CSV'
2021-07-10T09:34:1③940220Z 0 [Note] Shutting down plugin 'sha256_password'
2021-07-10T09:34:1③940223Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-07-10T09:34:1③940368Z 0 [Note] Shutting down plugin 'binlog'
2021-07-10T09:34:1③944566Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
# sudo tail /var/log/mysql/error.log
2021-07-10T10:06:4⑦917345Z 0 [ERROR] InnoDB: Unable to open './test/temporary_file.ibd': No such file or directory
2021-07-10T10:06:4⑦917362Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2021-07-10T10:06:4⑦917371Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-07-10T10:06:4⑦917376Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-07-10T10:06:4⑦917382Z 0 [ERROR] Failed to initialize plugins.
2021-07-10T10:06:4⑦917384Z 0 [ERROR] Aborting
2021-07-10T10:06:4⑦917388Z 0 [Note] Binlog end
2021-07-10T10:06:4⑦918108Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
以上就是土嘎嘎小编为大家整理的查看MySQL的错误日志的方法相关主题介绍,如果您觉得小编更新的文章只要能对粉丝们有用,就是我们最大的鼓励和动力,不要忘记讲本站分享给您身边的朋友哦！！