Can't find file mysql/plugin.frm” when starting up MySQL

byran cheung · 01-09-2014, 08:31 PM

When I start my MySQL server in my centos, I get this error:

/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.

I have run mysql_upgrade to rebuild it, it works to rebuild. Before I did it, I removed and installed MySQL. However, when I tried to re-start, I get the same error. I sure this is not a permission problem, as all files and directories are created by the mysql user.

Could you advise how to fix this error? thanks

l0p3n · 01-11-2014, 05:06 AM

Quote:

Originally Posted by byran cheung

When I start my MySQL server in my centos, I get this error:

/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.

I have run mysql_upgrade to rebuild it, it works to rebuild. Before I did it, I removed and installed MySQL. However, when I tried to re-start, I get the same error. I sure this is not a permission problem, as all files and directories are created by the mysql user.

Could you advise how to fix this error? thanks

I think I found a similar issue in this thread http://www.linuxquestions.org/questi...issues-789786/. I hope it is to any help.