剛安裝完MYSQL,無(wú)法啟動(dòng)

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

為什么會(huì)出現(xiàn)這個(gè)目錄呀??140406 21:15:45 [ERROR] /usr/local/mysql/libexec/mysqld: Can't create/write to f
ile '/var/run/mysqld/mysqld.pid' (Errcode: 2)
難道要我去手動(dòng)創(chuàng)建這個(gè)目錄嗎??請(qǐng)教下各位,誰(shuí)來(lái)幫忙看看

webdna

是不是你權(quán)限不夠呢？

astronomer_merc

回復(fù) 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]#

應(yīng)該沒(méi)有錯(cuò)吧SELINUX我也關(guān)閉了

gu_jj

/var/run/mysqld/mysqld.pid 權(quán)限吧

astronomer_merc

回復(fù) 4# gu_jj


    話說(shuō)其實(shí)我去查了下/var/run/，下面沒(méi)有mysqld.....后來(lái)把/etc/my.cnf修改了就好了.../usr/local/mysql/libexec/mysqld沒(méi)有配對(duì)...
感謝答謝的關(guān)注我的問(wèn)題