/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)

最新推荐文章于 2024-02-22 09:42:29 发布

原创最新推荐文章于 2024-02-22 09:42:29 发布 · 3.4k 阅读

CC 4.0 BY-SA版权

本文记录了一次MySQL服务启动失败的情况，错误信息显示无法找到文件'./mysql/plugin.frm'，并提示运行mysql_upgrade来创建mysql插件表。此外，还遇到了InnoDB文件操作权限问题，具体表现为无法打开文件'./ibdata1'。

[root@localhost ~]# /etc/init.d/mysqld start
MySQL Daemon failed to start.
正在启动 mysqld：                                          [失败]
[root@localhost ~]# cat /var/log/mysqld.log
180107 21:35:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/                                          mysql
180107 21:35:19 [Warning] '--default-character-set' is deprecated and will be re                                          moved in a future release. Please use '--character-set-server' instead.
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
180107 21:35:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr                                          ade to create it.
180107 21:35:19  InnoDB: Initializing buffer pool, size = 8.0M
180107 21:35:19  InnoDB: Completed initialization of buffer pool
180107 21:35:19  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
180107 21:35:19 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende                                          d
180107 21:35:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/                                          mysql
180107 21:35:40 [Warning] '--default-character-set' is deprecated and will be re                                          moved in a future release. Please use '--character-set-server' instead.
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
180107 21:35:40 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr                                          ade to create it.
180107 21:35:40  InnoDB: Initializing buffer pool, size = 8.0M
180107 21:35:40  InnoDB: Completed initialization of buffer pool
180107 21:35:40  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
180107 21:35:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende                                          d
180107 21:37:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/                                          mysql
180107 21:37:46 [Warning] '--default-character-set' is deprecated and will be re                                          moved in a future release. Please use '--character-set-server' instead.
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
180107 21:37:46 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr                                          ade to create it.
180107 21:37:46  InnoDB: Initializing buffer pool, size = 8.0M
180107 21:37:46  InnoDB: Completed initialization of buffer pool
180107 21:37:46  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
180107 21:37:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende                                          d