Home > Database > Mysql Tutorial > body text

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

WBOY
Release: 2016-06-07 15:24:56
Original
1571 people have browsed it

[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  ]
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template