I've just rebooted my Ubuntu server and MySQL just won't start for some reason! I'm using:
/etc/init.d/mysql start
I just get this:
* Starting MySQL database server mysqld [fail]
Why might this be happening? Apache is running and my site works OK apart from the database connection. MySQL server is installed normally via synaptic.
I ran:
sh -x /etc/init.d/mysql start
Which listed this among the output:
+ echo -e 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in\n/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!\n
I followed the advice here for creating the .sock file but no luck.
(Let me know any more information you need me to provide.)
Update: I ran mysqld
since the output above mentioned it, and got this error:
100516 17:37:57 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.
Any idea what it means, or what file it refers to?
/var/log/mysql.err
and/var/log/mysql.log
are empty.