红联Linux门户
Linux帮助

MYSQL无法启动全是奇了

发布时间:2008-08-13 20:50:18来源:红联作者:panasonic
系统版本
LSB Version: :core-3.0-ia32:core-3.0-noarch:graphics-3.0-ia32:graphics-3.0-noarch
Distributor ID: RedHatEnterpriseAS
Description: Red Hat Enterprise Linux AS release 4 (Nahant Update 5)
Release: 4
Codename: NahantUpdate5

MYSQL版本
mysql-5.0.22.tar.gz


错误提示
/usr/local/mysql/bin/mysqld_safe --user=mysql &
[1] 11153
[root@server-39 mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/server-39.pid
080813 22:21:18 mysqld ended

报错日志
/usr/local/mysql/libexec/mysqld: Can't read dir of '/tmp/' (Errcode: 13)
/usr/local/mysql/libexec/mysqld: Can't create/write to file '/tmp/ibrDizBz' (Err
code: 13)
080813 22:21:18 InnoDB: Error: unable to create temporary file; errno: 13
080813 22:21:18 [ERROR] Can't start server : Bind on unix socket: Permission den
ied
080813 22:21:18 [ERROR] Do you already have another mysqld server running on soc
ket: /tmp/mysql.sock ?
080813 22:21:18 [ERROR] Aborting

080813 22:21:18 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

080813 22:21:18 mysqld ended

分析报错日志
1、经对/tmp 设权限chmod 1777 由于我是ROOT操作,chown -R root:root /tmp
2、日志当中提示,说我另外一个程序在运行,ps -axu |grep mysql看过没有。
3、my.cnf里面 /tmp/mysql.sock 指向是正确的
4、最后我对MYSQL重装过好几次全是一模一样问题。
文章评论

共有 2 条评论

  1. panasonic 于 2008-08-13 21:46:14发表:

    格式写全点这样,看不懂

  2. uvbsldwm 于 2008-08-13 20:57:53发表:

    执行equery f mysql,看安装文件有无包含/var/run/mysqld,如果没有就创建此目录,并chown