Mysql运行的STOPPING server from pid file /var/run/mysqld/mysqld.pid错误

最新推荐文章于 2023-06-28 04:45:00 发布
原创 最新推荐文章于 2023-06-28 04:45:00 发布 · 6.9k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#mysql #file #server #linux

本文记录了在Linux环境下遇到的MySQL启动失败问题，并详细描述了解决过程。主要错误为无法创建或写入mysqld.pid文件，通过创建相应目录并调整权限最终解决了该问题。

晕倒,刚才写的东西全没了.....

     今天在linux上安装出现了如下错误:

STOPPING server from pid file /var/run/mysqld/mysqld.pid
051111 10:35:27  mysqld ended


[1]+  Done                    bin/mysqld_safe --user=mysql

    看了下/var/lib/mysql日志文件,有如下提示:

051110 10:33:54  InnoDB: Started; log sequence number 0 43655
051110 10:33:54 [ERROR] /usr/local/mysql-max-5.0.15-linux-i686-glibc23/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
051110 10:33:54 [ERROR] Can't start server: can't create PID file: No such file or directory
051110 10:33:54  mysqld ended

 看出有文件未找到的错误,尝试了如下命令: 

mkdir /var/run/mysqld

    运行mysql,错误依旧.

在网上查了下,说还有可能是权限问题,于是尝试:

chown -R mysql /var/run/mysqld
chgrp -R mysql /var/run/mysqld

    Success!

ariest
关注
MySQL无法正常启动（mysqld ended） 的解决方案及环境变量配置
ADreamClusive的博客
05-15 3311
启动mysql时报错：  Starting mysqld daemon with databases from /var/lib/mysql  STOPPING server from pid file /var/run/mysqld/mysqld.pid  071112 00:22:06 mysqld ended    1 首先查看日志 ＃less /var/log/mysqld.log ...
var run mysql mysqld_MySQL启动错误：Error writing file '/var/run/mysqld/mysqld.pid'
weixin_39582656的博客
02-01 236
通常是因为磁盘空间已满造成的，你需要知道原因和如何预防。你可以通过df -h来查看磁盘情况。[root@techbrood etc]# df -hFilesystem Size Used Avail Use% Mounted on/dev/sda1 ?G ?G ?G 100%/...Use%=100%表示根目录空间已满，无法再创建或写入内容。...
mysql pid无法写入_ERROR /usr/libexec/mysqld：写入文件'/var/run/mysqld/mysqld.pid'时出错(错误代码：28)...
weixin_39752087的博客
02-07 530
目前我在Linux Centos上遇到了一个与MySQL有关的问题。它突然停止了。所以然后我试图启动与服务mysqld启动命令的MySQL，它给错误 -尝试启动MySQL守护程序时发生超时错误。我用尾部-10 /var/log/mysqld.log命令检查了日志，然后显示 -120714 6:48:02 InnoDB: Initializing buffer pool, size = 8.0M...
linux mysql不能启动不了,linux下，关于mysql不能启动的问题
weixin_42144554的博客
05-11 377
在redhat5.5下，安装mysql，安装结束却不能启动，内容如下：[root@localhost mysql]# /usr/local/mysql/bin/mysqld_safe &[1] 4477[root@localhost mysql]# Starting mysqld daemon with databases from /usr/local/mysql/varSTOPPING...
Mysql 错误处理--pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)
倦鸟归时
07-22 8759
chown mysql:mysql -R /var/lib/mysql（根据需要可以更改为自定义目录）
MySQL启动错误：Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
陈小峰（iefreer）的专栏
08-06 1万+
这个错误的原因可能是下面
-- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 16:01:55 localhost.localdomain mysql-systemd-start[12907]: 2025-06-19 16:01:55 0 [Note] / usr/sbin/mysqld (mysqld 5.6.51) starting as process 12930 ... 6月 19 16:01:55 localhost.localdomain mysql-systemd-start[12907]: 2025-06-19 16:01:55 12930 [Not e] /usr/sbin/mysqld: Shutdown complete 6月 19 16:01:55 localhost.localdomain mysql-systemd-start[12907]: 2025-06-19 16:01:55 0 [Note] / usr/sbin/mysqld (mysqld 5.6.51) starting as process 12941 ... 6月 19 16:01:55 localhost.localdomain mysql-systemd-start[12907]: 2025-06-19 16:01:55 12941 [Not e] /usr/sbin/mysqld: Shutdown complete 6月 19 16:01:55 localhost.localdomain mysql-systemd-start[12907]: --defaults-file argument to my sqld_safe when starting the server 6月 19 16:01:56 localhost.localdomain mysqld_safe[12953]: 250619 16:01:56 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 16:01:56 localhost.localdomain mysqld_safe[12953]: 250619 16:01:56 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 16:01:56 localhost.localdomain mysqld_safe[12953]: 250619 16:01:56 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended 6月 19 16:11:55 localhost.localdomain systemd[1]: mysqld.service start-post operation timed out. Stopping. -- Subject: Unit mysqld.service has failed -- Unit mysqld.service has failed. 6月 19 16:11:55 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state. 6月 19 16:11:55 localhost.localdomain systemd[1]: mysqld.service failed. 6月 19 16:11:56 localhost.localdomain systemd[1]: mysqld.service holdoff time over, scheduling r estart. -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 16:11:56 localhost.localdomain mysqld_safe[19213]: 250619 16:11:56 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 16:11:56 localhost.localdomain mysqld_safe[19213]: 250619 16:11:56 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 16:11:57 localhost.localdomain mysqld_safe[19213]: 250619 16:11:57 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 16:23:58 localhost.localdomain mysql-systemd-start[27149]: 2025-06-19 16:23:58 0 [Note] / usr/sbin/mysqld (mysqld 5.6.51) starting as process 27165 ... 6月 19 16:24:00 localhost.localdomain mysql-systemd-start[27149]: 2025-06-19 16:24:00 0 [Note] / usr/sbin/mysqld (mysqld 5.6.51) starting as process 27201 ... 6月 19 16:24:02 localhost.localdomain mysql-systemd-start[27149]: --defaults-file argument to my sqld_safe when starting the server 6月 19 16:24:03 localhost.localdomain mysqld_safe[27239]: 250619 16:24:03 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 16:24:03 localhost.localdomain mysqld_safe[27239]: 250619 16:24:03 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql -- Subject: Unit mysqld.service has finished start-up -- Unit mysqld.service has finished starting up. -- Subject: Unit mysqld.service has begun shutting down -- Unit mysqld.service has begun shutting down. 6月 19 16:42:34 localhost.localdomain mysqld_safe[27239]: 250619 16:42:34 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 16:42:35 localhost.localdomain mysqld_safe[35199]: 250619 16:42:35 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 16:42:35 localhost.localdomain mysqld_safe[35199]: 250619 16:42:35 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql -- Subject: Unit mysqld.service has finished start-up -- Unit mysqld.service has finished starting up. 6月 19 17:22:37 localhost.localdomain sudo[52110]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl restart mysqld -- Subject: Unit mysqld.service has begun shutting down -- Unit mysqld.service has begun shutting down. 6月 19 17:22:38 localhost.localdomain mysqld_safe[35199]: 250619 17:22:38 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:22:39 localhost.localdomain mysqld_safe[52143]: 250619 17:22:39 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:22:39 localhost.localdomain mysqld_safe[52143]: 250619 17:22:39 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:22:41 localhost.localdomain mysqld_safe[52143]: 250619 17:22:41 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended 6月 19 17:23:26 localhost.localdomain sudo[52851]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl restart mysqld -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:23:26 localhost.localdomain mysqld_safe[52874]: 250619 17:23:26 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:23:26 localhost.localdomain mysqld_safe[52874]: 250619 17:23:26 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:23:28 localhost.localdomain mysqld_safe[52874]: 250619 17:23:28 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:24:11 localhost.localdomain mysqld_safe[53592]: 250619 17:24:11 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:24:11 localhost.localdomain mysqld_safe[53592]: 250619 17:24:11 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:24:14 localhost.localdomain mysqld_safe[53592]: 250619 17:24:14 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended 6月 19 17:25:12 localhost.localdomain systemd[1]: mysqld.service: control process exited, code=k illed status=9 -- Subject: Unit mysqld.service has failed -- Unit mysqld.service has failed. 6月 19 17:25:12 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state. 6月 19 17:25:12 localhost.localdomain systemd[1]: mysqld.service failed. 6月 19 17:25:12 localhost.localdomain systemd[1]: mysqld.service holdoff time over, scheduling r estart. -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:25:13 localhost.localdomain mysqld_safe[54465]: 250619 17:25:13 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:25:13 localhost.localdomain mysqld_safe[54465]: 250619 17:25:13 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:25:15 localhost.localdomain mysqld_safe[54465]: 250619 17:25:15 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended 6月 19 17:25:34 localhost.localdomain sudo[54929]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl restart mysqld -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:25:34 localhost.localdomain mysqld_safe[54953]: 250619 17:25:34 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:25:34 localhost.localdomain mysqld_safe[54953]: 250619 17:25:34 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:25:36 localhost.localdomain mysqld_safe[54953]: 250619 17:25:36 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended 6月 19 17:26:42 localhost.localdomain sudo[55901]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/pkill -9 mysqld 6月 19 17:26:49 localhost.localdomain sudo[55973]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/mysqld_safe --defaults-file=/etc/my.cnf 6月 19 17:31:13 localhost.localdomain sudo[58906]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl status mysqld 6月 19 17:33:49 localhost.localdomain sudo[60461]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl status mysqld 6月 19 17:33:59 localhost.localdomain sudo[60563]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/sbin/service mysqld status 6月 19 17:34:08 localhost.localdomain sudo[60663]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl start mysqld 6月 19 17:34:32 localhost.localdomain sudo[60935]: root : TTY=pts/0 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl start mysqld 6月 19 17:34:50 localhost.localdomain sudo[61150]: root : TTY=pts/0 ; PWD=/root ; USER=root ; COMMAND=/sbin/service mysqld status 6月 19 17:35:34 localhost.localdomain systemd[1]: mysqld.service start-post operation timed out. Stopping. -- Subject: Unit mysqld.service has failed -- Unit mysqld.service has failed. 6月 19 17:35:34 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state. 6月 19 17:35:34 localhost.localdomain systemd[1]: mysqld.service failed. 6月 19 17:35:34 localhost.localdomain systemd[1]: mysqld.service holdoff time over, scheduling r estart. -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:35:35 localhost.localdomain mysqld_safe[61625]: 250619 17:35:35 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:35:35 localhost.localdomain mysqld_safe[61625]: 250619 17:35:35 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:35:37 localhost.localdomain mysqld_safe[61625]: 250619 17:35:37 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended
06-20
查看日志以获取具体错误信息：```bashtail-n100/var/log/mysqld.log```###步骤2:检查文件权限引用[1]中提到的锁文件（lockfile）和PID文件（PIDfile）无法更新，很可能是权限问题。确保MySQL的数据目录（通常是`/var...
./mysql.server stop MySQL server PID file could not be found! [FAILED]
最新发布
12-03
当你运行 `./mysql.server stop` 命令时出现： ``` MySQL server PID file could not be found! [FAILED] ``` 这表示 MySQL 的启动脚本无法找到 **PID 文件**，而这个文件通常记录了 MySQL 主进程（mysqld）的进程...
mysql> exit Bye [root@localhost ~]# systemctl status mysql ● mysql.service - LSB: start and stop MySQL Loaded: loaded (/etc/rc.d/init.d/mysql; bad; vendor preset: disabled) Active: active (running) since 三 2025-10-01 12:33:37 CST; 1h 11min ago Docs: man:systemd-sysv-generator(8) Process: 57585 ExecStart=/etc/rc.d/init.d/mysql start (code=exited, status=0/SUCCESS) Tasks: 43 Memory: 77.5M CGroup: /system.slice/mysql.service ├─57590 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/localhost.pid └─57677 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=localhost.err --pid-file=/usr/local/my... 10月 01 12:33:33 localhost systemd[1]: Starting LSB: start and stop MySQL... 10月 01 12:33:37 localhost mysql[57585]: Starting MySQL... SUCCESS! 10月 01 12:33:37 localhost systemd[1]: Started LSB: start and stop MySQL.
10-02
Process: 1235 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid (code=exited, status=0/SUCCESS) Main PID: 1235 (code=exited, status=0/SUCCESS) May 10 15:17:22 ubuntu systemd...
root@yz-virtual-machine:/mnt/hgfs/code-docker/app# docker logs account-mysql 2025-08-22 14:50:58+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.43-1.el9 started. 2025-08-22 14:50:59+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2025-08-22 14:50:59+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.43-1.el9 started. 2025-08-22 14:50:59+08:00 [Note] [Entrypoint]: Initializing database files 2025-08-22T06:50:59.210355Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2025-08-22T06:50:59.210409Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.43) initializing of server in progress as process 79 2025-08-22T06:50:59.213480Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-08-22T06:50:59.379367Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-08-22T06:50:59.895191Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2025-08-22 14:51:01+08:00 [Note] [Entrypoint]: Database files initialized 2025-08-22 14:51:01+08:00 [Note] [Entrypoint]: Starting temporary server 2025-08-22T06:51:01.707921Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2025-08-22T06:51:01.708904Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.43) starting as process 123 2025-08-22T06:51:01.716706Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-08-22T06:51:01.802794Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-08-22T06:51:01.934075Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-08-22T06:51:01.934111Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-08-22T06:51:01.935212Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2025-08-22T06:51:01.943302Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock 2025-08-22T06:51:01.943415Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.43' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL. 2025-08-22 14:51:01+08:00 [Note] [Entrypoint]: Temporary server started. '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it. 2025-08-22 14:51:03+08:00 [Note] [Entrypoint]: Creating database account-db 2025-08-22 14:51:03+08:00 [Note] [Entrypoint]: Stopping temporary server 2025-08-22T06:51:03.104429Z 11 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.43). 2025-08-22T06:51:04.412829Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.43) MySQL Community Server - GPL. 2025-08-22 14:51:05+08:00 [Note] [Entrypoint]: Temporary server stopped 2025-08-22 14:51:05+08:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up. 2025-08-22T06:51:05.301901Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2025-08-22T06:51:05.302811Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.43) starting as process 1 2025-08-22T06:51:05.305779Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-08-22T06:51:05.387864Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-08-22T06:51:05.452214Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-08-22T06:51:05.452251Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-08-22T06:51:05.453178Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2025-08-22T06:51:05.460313Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock 2025-08-22T06:51:05.460364Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.43' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL. root@yz-virtual-machine:/mnt/hgfs/code-docker/app# docker-compose ps
08-23
Version: '8.0.xx' socket: '/var/run/mysqld/mysqld.sock' port: 3306 如果状态不是Up，或者日志中有错误信息（如无法分配内存、配置文件错误、端口已被占用等），则需要根据具体错误进行排查。 常见错误及...
var run mysql mysqld,pid文件/var/run/mysqld/mysqld.pid中的mysqld_safe mysqld阻止服务器重新启动...
weixin_31018573的博客
01-27 1129
My mySQL server on CentOS has been working correctly,but, I am unable to restart mysqld suddenly today.1)# /etc/rc.d/init.d/mysqld startshows [failed]2) see the logtail /var/log/mysqld.log..mysqld_saf...
Mysql5.7运行报错The server quit without updating PID file (/var/run/mysqld/mysqld.pid)解决方案2
weixin_46019007的博客
11-11 2674
mysql报错The server quit without updating PID file (/var/run/mysqld/mysqld.pid)解决方案2
mysql启动不了
Noxi_lumors的博客
04-23 2714
问题背景 service mysqld stop 没办法停止mysqld ，未找到其根本原因，直接暴力kill掉mysql 进程 然而 service mysqld start 又启动【FAILED】 这个时候, 脑抽地直接 [root@localhost~]# mysql ERROR 2002(HY000): Can’t connect to local MySQL server throug...
Failed to read PID from file /var/run/nginx.pid: Invalid argument
lw545034502的博客
08-31 1981
报错： /usr/local/nginx/sbin/nginx -c /usr/local/nginx/conf/nginx.conf
【吭】Failed to parse PID from file /run/nginx.pid: Invalid argument
Teamo_mc的博客
09-10 802
参考资料：Failed to parse PID from file /run/nginx.pid: Invalid argument_噢，乖-优快云博客查看Nginx状态，发现报错Failed to parse PID from file /run/nginx.pid: Invalid argument mkdir -p /etc/systemd/system/nginx.service.d printf "[Service]\nExecStartPost=/bin/sleep 0.1\n" >/
mysql错误: STOPPING server from pid file /tmp/mysqld.pid
adwfcu的专栏
10-21 3374
执行/usr/bin/mysqld_safe &后 出现：Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /tmp/mysqld.pid 061026 20:32:33  mysqld ended 1.data文件夹的mysql权限没有给出！ 执行命令：
Failed to parse PID from file /run/nginx.pid: Invalid argument
m0_73414822的博客
06-28 2040
nginx启动，查看状态报错 Failed to parse PID from file /run/nginx.pid: Invalid argument
Mysql5.7运行报错The server quit without updating PID file (/var/run/mysqld/mysqld.pid)解决方案1
weixin_46019007的博客
03-31 2万+
mysql报错The server quit without updating PID file (/var/run/mysqld/mysqld.pid)解决方案1
MySQL 启动失败报错无法更新pid文件
热门推荐
企业实战系列集 ●●● https://ximenjianxue.blog.youkuaiyun.com
05-09 4万+
一、问题描述 某次因MySQL故障，一线人员反馈MySQL启动，一直无法启动，报错：启动mysql失败 ERROR! The server quit without updating PID file (/usr/local/mysql/data/mysql.pid). 二、问题分析 1）pid文件缺失，MySQL本身存在重启pid文件丢失，重启不会重建的问题。可能原因： mysql的端口被占用 生成pid文件的目录mysql的权限不足 mysql对应的my.cnf配置文件错误 mysql的启动脚本有问题
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值