MySQL Daemon failed to start
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/mysqld.pid 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
Subject
Written By
Posted
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.