VPS侦探论坛

 找回密码
 注册
查看: 107|回复: 3

ERROR! MySQL PID file could not be found! 求助

[复制链接]
发表于 2022-1-10 22:03:49 | 显示全部楼层 |阅读模式



2022-01-10 21:56:02 4247 [Note] Plugin 'FEDERATED' is disabled.
2022-01-10 21:56:02 4247 [Note] InnoDB: Using atomics to ref count buffer pool pages
2022-01-10 21:56:02 4247 [Note] InnoDB: The InnoDB memory heap is disabled
2022-01-10 21:56:02 4247 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-01-10 21:56:02 4247 [Note] InnoDB: Memory barrier is not used
2022-01-10 21:56:02 4247 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-01-10 21:56:02 4247 [Note] InnoDB: Using Linux native AIO
2022-01-10 21:56:02 4247 [Note] InnoDB: Using CPU crc32 instructions
2022-01-10 21:56:02 4247 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2022-01-10 21:56:02 4247 [Note] InnoDB: Completed initialization of buffer pool
2022-01-10 21:56:02 4247 [ERROR] InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
2022-01-10 21:56:02 4247 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2022-01-10 21:56:02 4247 [Note] InnoDB: Retrying to lock the first data file
2022-01-10 21:56:03 4247 [ERROR] InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
2022-01-10 21:56:03 4247 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2022-01-10 21:56:04 4247 [ERROR] InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
2022-01-10 21:56:04 4247 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2022-01-10 21:56:05 4247 [ERROR] InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
2022-01-10 21:56:05 4247 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2022-01-10 21:56:06 4247 [ERROR] InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
2022-01-10 21:56:06 4247 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2022-01-10 21:56:07 4247 [ERROR] InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
2022-01-10 21:56:07 4247 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2022-01-10 21:56:08 4247 [ERROR] InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
2022-01-10 21:56:08 4247 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2022-01-10 21:56:09 4247 [ERROR] InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
2022-01-10 21:56:09 4247 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2022-01-10 21:56:10 4247 [ERROR] InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
2022-01-10 21:56:10 4247 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2022-01-10 21:56:11 4247 [ERROR] InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
2022-01-10 21:56:11 4247 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2022-01-10 21:56:12 4247 [ERROR] InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
2022-01-10 21:56:12 4247 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2022-01-10 21:56:13 4247 [ERROR] InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11

美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2022-1-11 08:54:30 | 显示全部楼层


mysql已经在运行了
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 2022-1-11 11:11:01 | 显示全部楼层



也就是说这种情况是正常的是吗? 谢谢解答
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2022-1-11 15:18:04 | 显示全部楼层



1600160996 发表于 2022-1-11 11:11
也就是说这种情况是正常的是吗? 谢谢解答

具体要看你进行的什么操作,如果是mysql已经启动,再去启动就会是这个提示
如果是mysql无法正常登录使用有可能mysql挂了,需要kill 掉mysqld_safe进程的PID,再去启动
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2022-1-19 18:45 , Processed in 0.045611 second(s), 16 queries .

Powered by Discuz! X3.4

Copyright © 2001-2021, Tencent Cloud.

快速回复 返回顶部 返回列表