☰

mysqli::real_connect(): (HY000/2002): 没有此文件或目录

tag-icon • tag-icon networking server permissions mysql nginx
mysqli::real_connect(): (HY000/2002): 没有此文件或目录

我的 MySQL 服务突然停止了。

● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Thu 2021-06-10 10:56:09 UTC; 18min ago
    Process: 1378 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
    Process: 1386 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
   Main PID: 1386 (code=exited, status=1/FAILURE)
     Status: "Server startup in progress"
      Error: 13 (Permission denied)

Jun 10 10:56:09 ssdnodes-6033b79bb86b3 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Jun 10 10:56:09 ssdnodes-6033b79bb86b3 systemd[1]: mysql.service: Failed with result 'exit-code'.
Jun 10 10:56:09 ssdnodes-6033b79bb86b3 systemd[1]: Failed to start MySQL Community Server.
Jun 10 10:56:09 ssdnodes-6033b79bb86b3 systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Jun 10 10:56:09 ssdnodes-6033b79bb86b3 systemd[1]: Stopped MySQL Community Server.
Jun 10 10:56:09 ssdnodes-6033b79bb86b3 systemd[1]: mysql.service: Start request repeated too quickly.
Jun 10 10:56:09 ssdnodes-6033b79bb86b3 systemd[1]: mysql.service: Failed with result 'exit-code'.
Jun 10 10:56:09 ssdnodes-6033b79bb86b3 systemd[1]: Failed to start MySQL Community Server.
root@ssdnodes-6033b79bb86b3:~#

错误日志显示此错误：

mysqld: File './binlog.index' not found (OS errno 13 - Permission denied)
2021-06-10T10:56:09.263519Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.20.04.1) starting as process 1377
2021-06-10T10:56:09.265942Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-06-10T10:56:09.266149Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.25-0ubuntu0.20.04.1)  (Ubuntu).
mysqld: File './binlog.index' not found (OS errno 13 - Permission denied)
2021-06-10T10:56:09.768183Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.20.04.1) starting as process 1386
2021-06-10T10:56:09.771054Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-06-10T10:56:09.771264Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.25-0ubuntu0.20.04.1)  (Ubuntu).

相关内容