MySQL fails on startup - "Can't create/write to file"

n000b

Well-Known Member
Apr 7, 2005
142
0
166
When I reboot my server, MySQL fails to start up. I get the following message in mysqld.log:

070914 23:49:10 mysqld started
^G/usr/sbin/mysqld: Can't create/write to file '/tmp/ibuZXXqz' (Errcode: 13)
070914 23:49:10 InnoDB: Error: unable to create temporary file; errno: 13
070914 23:49:10 [ERROR] Can't init databases
070914 23:49:10 [ERROR] Aborting

070914 23:49:10 [Note] /usr/sbin/mysqld: Shutdown complete

070914 23:49:10 mysqld ended

My /tmp directory seems to have the correct permissions:

drwxrwxrwt 7 root root 104448 Sep 15 23:52 tmp/

However, interestingly when I manually start MySQL (either through SSH via "/etc/init.d/mysqld start" or via cPanel), it comes up without error. So it only seems to fail to start when the system is coming online.

Anyone know what causes this?