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

N

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
Click to expand...

My /tmp directory seems to have the correct permissions:

drwxrwxrwt 7 root root 104448 Sep 15 23:52 tmp/
Click to expand...

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?
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
S Upgrade MySQL 5.6 to MariaDB 10.3 fails due to repo problem Databases 6
S SOLVED mysqldump fails for non-root shell user Databases 5
C MySQL fails and recovers every morning Databases 1
D MySQL fails to start - quit without updating PID file Databases 7
J MySQL Randomly Fails then Recovers Databases 4
Similar threads
Upgrade MySQL 5.6 to MariaDB 10.3 fails due to repo problem
SOLVED mysqldump fails for non-root shell user
MySQL fails and recovers every morning
MySQL fails to start - quit without updating PID file
MySQL Randomly Fails then Recovers
Top Bottom