Heim  >  Artikel  >  Datenbank  >  The server quit without updating PID file (/[FAILED]l/mysql/

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

WBOY
WBOYOriginal
2016-06-07 15:24:561559Durchsuche

[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  ]
Stellungnahme:
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn