Q. I’m using Red Hat enterprise Linux version 4.0 and MySQL version 4.20. Monit has recently notified me following error:
mysqld' failed to start.
A detailed log from /var/log/mysqld.log file:
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibCfJwf1' (Errcode: 13)
070420 10:07:58 InnoDB: Error: unable to create temporary file; errno: 13
070420 10:07:58 [ERROR] Can't init databases
070420 10:07:58 [ERROR] Aborting
070420 10:07:58 [Note] /usr/libexec/mysqld: Shutdown complete
/etc/init.d/mysql start command returned following output:
Initializing MySQL database: [ OK ]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
How do I fix this problem?
A. MySQL is not able to access your /tmp directory to wirte and create temporary files. Make sure /tmp is owned by root and sticky bit is set on /tmp directory. Type the following commands to fix the error:
# chown root:root /tmp
# chmod 1777 /tmp
# /etc/init.d/mysqld start
Now mysql should start without a problem.
Featured Articles:
- 20 Linux System Monitoring Tools Every SysAdmin Should Know
- My 10 UNIX Command Line Mistakes
- 10 Greatest Open Source Software Of 2009
- Top 5 Email Client For Linux, Mac OS X, and Windows Users
- Top 20 OpenSSH Server Best Security Practices
- Top 10 Open Source Web-Based Project Management Software
- Top 5 Linux Video Editor Software
- Email FAQ to a friend
- Download PDF version
- Printable version
- Comment RSS feed
- Last Updated: 04/20/07
{ 19 comments… read them below or add one }
Oh, dear. Thank you so much. You have save the day. I had this problem and found your site on Google and it works!!! thank you so much
Thank a lot for posting answer. I had this problem and found your site on Google and its solve my problem!!!
THX!
It’s not solving my problem. It’s still not starting. The same error shows up in the log file :(
Didn’t fix mine either although my error was slightly different:
081127 2:38:09 [Warning] Can’t create test file /var/lib/mysql/bobby.lower-test
081127 2:38:09 [Warning] Can’t create test file /var/lib/mysql/bobby.lower-test
/usr/libexec/mysqld: Can’t change dir to ‘/var/lib/mysql/’ (Errcode: 13)
081127 2:38:09 [ERROR] Aborting
WHo can help me with this?
Thanks your a genius works a treat was getting an error when restoring back up now everything fine
Where should I type the commands to fix the error?
I use VertrigoSerwer 2.21
(Appache 2.0.63; PHP 5.2.6; MySQL 5.0.51b PhpMyAdmin 2.11.7)
This is WAP for Windows XP.
Thank you for posting the fix. Mine is working after that.
Best regards.
It still not works. It is not perfect solution.
Please give me other solution
as usual, great article :)
thank you .. you save my day … i love you full hahaha
Worked like magic, thanks man…
u rock. was going nuts!. thanks bruv
use system-config-securitylevel-tui
Security Level = Disable
SELinux = DISABLE
!!!!
Thank you!!! A website that someone built 5 years ago just stopped working today, and I couldn’t figure it out until coming across this solution. You’re a lifesaver!
I’m getting an error while starting mysqld in windows xp sp2. The error saying:
mysqld: Error on delete of ‘C:\Program Files\iBerry Logics\server\MySQL\data\Com 1.lower-test’ (Errcode: 22)
Can anybody please help me?
Dear ,
Really It was helpful. Thanks..
But when i am restarting —– “/etc/init.d/mysqld start” instead of mysqld i put mysql then its started.
Any way thanks.
Regards,
bala
Hi,
The problem was solved and the issue was about the computer name. They named their computer as com1,com2 and com3. MySQL server started to run after i renamed their system.
Regards
Thank you,
This worked for me too.