MySQL Forums
Forum List  »  Newbie

MySQL Daemon failed to start
Posted by: Salam ELIAS
Date: October 24, 2010 04:30PM

I have a mysql which was working fine until this afternoon, I rebooted my machine I started getting this error
MySQL Daemon failed to start
In log files

/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
101025 0:21:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
101025 0:21:53 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.
101025 00:21:53 mysqld_safe mysqld from pid file /var/run/mysqld/ ended

I googled and found some threads about privileges around the mysql directory, it is owned by mysql user and has all rights, I tried running mysql_upgrade
I get

Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

Options: ReplyQuote

Written By
MySQL Daemon failed to start
October 24, 2010 04:30PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.