关闭

/usr/libexec/mysqld: Can’t create/write to file ‘/tmp/’ (Errcode: 13)

998人阅读 评论(0) 收藏 举报

转自:http://www.cyberciti.biz/faq/mysqld-innodb-error-unable-to-create-temporary-file/

在执行mysql_install_db的时候报错:/usr/libexec/mysqld: Can’t create/write to file ‘/tmp/’ (Errcode: 13)

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.

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:17370次
    • 积分:369
    • 等级:
    • 排名:千里之外
    • 原创:21篇
    • 转载:4篇
    • 译文:0篇
    • 评论:0条
    文章分类