刚安装完MYSQL,无法启动

astronomer_merc

[root@blast bin]# 140406 23:14:22 mysqld_safe Logging to '/var/log/mysqld.log'.
140406 23:14:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140406 23:14:22 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

[1]+  Done                    ./mysqld_safe --user=mysql
[root@blast bin]#
[root@blast log]# more mysqld.log
140406 21:15:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/
mysql
140406 21:15:45 [ERROR] /usr/local/mysql/libexec/mysqld: Can't create/write to f
ile '/var/run/mysqld/mysqld.pid' (Errcode: 2)
140406 21:15:45 [ERROR] Can't start server: can't create PID file: No such file
or directory
140406 21:15:45 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende
d
140406 21:25:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/
mysql
140406 21:25:23 [ERROR] /usr/local/mysql/libexec/mysqld: Can't create/write to f
ile '/var/run/mysqld/mysqld.pid' (Errcode: 2)
140406 21:25:23 [ERROR] Can't start server: can't create PID file: No such file
or directory
140406 21:25:23 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende
d
140406 21:27:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/
mysql
140406 21:27:47 [ERROR] /usr/local/mysql/libexec/mysqld: Can't create/write to f
ile '/var/run/mysqld/mysqld.pid' (Errcode: 2)
140406 21:27:47 [ERROR] Can't start server: can't create PID file: No such file
or directory
140406 21:27:47 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende
d
140406 23:14:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140406 23:14:22 [ERROR] /usr/local/mysql/libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
140406 23:14:22 [ERROR] Can't start server: can't create PID file: No such file or directory
140406 23:14:22 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

为什么会出现这个目录呀??140406 21:15:45 [ERROR] /usr/local/mysql/libexec/mysqld: Can't create/write to f
ile '/var/run/mysqld/mysqld.pid' (Errcode: 2)
难道要我去手动创建这个目录吗??请教下各位,谁来帮忙看看

webdna

是不是你权限不够呢？

astronomer_merc

回复 2# webdna



[root@blast local]# ll
total 64
drwxrwxrwx. 14 root root  4096 Apr  5 19:35 apache
drwxrwxrwx.  6 root root  4096 Apr  5 19:20 apr
drwxr-xr-x.  5 root root  4096 Apr  5 19:24 apr-util
drwxr-xr-x.  2 root root  4096 Sep 23  2011 bin
drwxr-xr-x.  2 root root  4096 Sep 23  2011 etc
drwxr-xr-x.  2 root root  4096 Sep 23  2011 games
drwxr-xr-x.  2 root root  4096 Sep 23  2011 include
drwxr-xr-x.  2 root root  4096 Sep 23  2011 lib
drwxr-xr-x.  2 root root  4096 Sep 23  2011 lib64
drwxr-xr-x.  2 root root  4096 Sep 23  2011 libexec
drwxr-xr-x. 11 root mysql 4096 Apr  6 22:59 mysql
drwxr-xr-x.  2 root root  4096 Apr  5 19:21 pcre
drwxr-xr-x.  2 root root  4096 Apr  5 20:38 php
drwxr-xr-x.  2 root root  4096 Sep 23  2011 sbin
drwxr-xr-x.  5 root root  4096 Apr  4 20:01 share
drwxr-xr-x.  2 root root  4096 Sep 23  2011 src
[root@blast local]# cd mysql/
[root@blast mysql]# ll
total 36
drwxr-xr-x.  2 root mysql 4096 Apr  6 22:51 bin
drwxr-xr-x.  2 root mysql 4096 Apr  6 22:35 data
drwxr-xr-x.  2 root mysql 4096 Apr  6 22:51 docs
drwxr-xr-x.  3 root mysql 4096 Apr  6 22:50 include
drwxr-xr-x.  3 root mysql 4096 Apr  6 22:51 lib
drwxr-xr-x.  2 root mysql 4096 Apr  6 22:59 libexec
drwxr-xr-x. 10 root mysql 4096 Apr  6 22:59 mysql-test
drwxr-xr-x.  5 root mysql 4096 Apr  6 22:59 share
drwxr-xr-x.  5 root mysql 4096 Apr  6 22:59 sql-bench
[root@blast mysql]#

应该没有错吧SELINUX我也关闭了

gu_jj

/var/run/mysqld/mysqld.pid 权限吧

astronomer_merc

回复 4# gu_jj


    话说其实我去查了下/var/run/，下面没有mysqld.....后来把/etc/my.cnf修改了就好了.../usr/local/mysql/libexec/mysqld没有配对...
感谢答谢的关注我的问题