The server quit without updating PID file (/[FAILED]l/mysql/var/localhost.localdomain.pid)

最新推荐文章于 2025-06-30 16:54:29 发布

原创最新推荐文章于 2025-06-30 16:54:29 发布 · 7.5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #startup #Errcode #13

mysql 专栏收录该内容

4 篇文章

订阅专栏

本文记录了一次解决MySQL服务启动失败的过程，通过调整配置文件、修改权限等步骤最终成功启动MySQL服务。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[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 ]