>  기사  >  데이터 베이스  >  The server quit without updating PID file (/[FAILED]l/mysql/

The server quit without updating PID file (/[FAILED]l/mysql/

WBOY
WBOY원래의
2016-06-07 15:24:561522검색

[root@localhost var]# vi /etc/my.cnf log-bin=/usr/local/mysql/data/mylog --添加log-bin参数 [root@localhost var]# service mysqld stop mysqld: unrecognized service [root@localhost var]# service mysql stop Shutting down MySQL.... [ OK ] [root

[root@localhost var]# vi /etc/my.cnf 

log-bin=/usr/local/mysql/data/mylog    --添加log-bin参数
[root@localhost var]# service mysqld stop
mysqld: unrecognized service
[root@localhost var]# service mysql stop
Shutting down MySQL....                                    [  OK  ]
[root@localhost var]# service mysql start
Starting MySQL.The server quit without updating PID file (/[FAILED]l/mysql/var/localhost.localdomain.pid).
[root@localhost var]# service mysql start
Starting MySQL.The server quit without updating PID file (/[FAILED]l/mysql/var/localhost.localdomain.pid).

[root@localhost var]# tail -25 localhost.localdomain.err 

140805 13:43:22 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/bin/mysqld: File '/usr/local/mysql/data/mylog.index' not found (Errcode: 13)
140805 13:43:22 [ERROR] Aborting

140805 13:43:22 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

140805 13:42:53 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended

[root@localhost mysql]# ll /usr/local/mysql/    

total 80
-rw-r--r--  1 root  mysql 17987 Aug 29  2012 COPYING
-rw-r--r--  1 root  mysql  7604 Aug 29  2012 INSTALL-BINARY
-rw-r--r--  1 root  mysql  2552 Aug 29  2012 README
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 bin
drwxr-xr-x  4 root  mysql  4096 Dec 26  2013 data
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 docs
drwxr-xr-x  3 root  mysql  4096 Dec 26  2013 include
drwxr-xr-x  3 root  mysql  4096 Dec 26  2013 lib
drwxr-xr-x  4 root  mysql  4096 Dec 26  2013 man
drwxr-xr-x 10 root  mysql  4096 Dec 26  2013 mysql-test
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 scripts
drwxr-xr-x 27 root  mysql  4096 Dec 26  2013 share
drwxr-xr-x  4 root  mysql  4096 Dec 26  2013 sql-bench
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 support-files
drwx------  5 mysql mysql  4096 Aug  5 13:46 var
[root@localhost mysql]# chown -R mysql /usr/local/mysql/data   --更改data目录属主
[root@localhost mysql]# ll /usr/local/mysql/
total 80
-rw-r--r--  1 root  mysql 17987 Aug 29  2012 COPYING
-rw-r--r--  1 root  mysql  7604 Aug 29  2012 INSTALL-BINARY
-rw-r--r--  1 root  mysql  2552 Aug 29  2012 README
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 bin
drwxr-xr-x  4 mysql mysql  4096 Dec 26  2013 data
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 docs
drwxr-xr-x  3 root  mysql  4096 Dec 26  2013 include
drwxr-xr-x  3 root  mysql  4096 Dec 26  2013 lib
drwxr-xr-x  4 root  mysql  4096 Dec 26  2013 man
drwxr-xr-x 10 root  mysql  4096 Dec 26  2013 mysql-test
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 scripts
drwxr-xr-x 27 root  mysql  4096 Dec 26  2013 share
drwxr-xr-x  4 root  mysql  4096 Dec 26  2013 sql-bench
drwxr-xr-x  2 root  mysql  4096 Dec 26  2013 support-files
drwx------  5 mysql mysql  4096 Aug  5 13:46 var
[root@localhost mysql]# service mysql start
Starting MySQL..                                           [  OK  ]
성명:
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.