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

1600160996

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

licess

mysql已经在运行了

1600160996

也就是说这种情况是正常的是吗? 谢谢解答

licess

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

具体要看你进行的什么操作，如果是mysql已经启动，再去启动就会是这个提示
如果是mysql无法正常登录使用有可能mysql挂了，需要kill 掉mysqld_safe进程的PID，再去启动