主页 / ubuntu / 问题 / 1228827
Accepted
Nate
Asked: 2020-04-21 06:33:38 +0800 CST

MYSQL 错误：13（权限被拒绝）

  • 772

我得到 *Job for mysql.service failed 因为控制进程以错误代码退出。

See "systemctl status mysql.service" and "journalctl -xe" for details.*

当我运行该命令时，我得到

● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Mon 2020-04-20 09:32:04 CDT; 19s ago
  Process: 7287 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
  Process: 7295 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
 Main PID: 7295 (code=exited, status=1/FAILURE)
   Status: "Server startup in progress"
    Error: 13 (Permission denied)

Apr 20 09:32:04 sturtz.ml systemd[1]: mysql.service: Service RestartSec=100ms expired, scheduling restart.
Apr 20 09:32:04 sturtz.ml systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Apr 20 09:32:04 sturtz.ml systemd[1]: Stopped MySQL Community Server.
Apr 20 09:32:04 sturtz.ml systemd[1]: mysql.service: Start request repeated too quickly.
Apr 20 09:32:04 sturtz.ml systemd[1]: mysql.service: Failed with result 'exit-code'.
Apr 20 09:32:04 sturtz.ml systemd[1]: Failed to start MySQL Community Server.*
mysql 19.10

2 个回答

  1. Best Answer

    我运行了以下命令，它在 Ubuntu Server 19.10 上运行：

    sudo chown -R mysql:mysql /var/lib/mysql/
    • 9

  2. 您可以登录到/var/log/mysqld路径并检查mysql错误。

    tail -f /var/log/mysqld.log

    然后就可以看到权限错误路径了。示例如下。

    "2021-01-13T04:46:06.336009Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-000001 - Can't create/write to file '**/var/run/mysqld/mysqld.pid**' (OS errno 13 - Permission denied)"

    现在您可以使用以下命令授予对上述路径的访问权限：

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

    之后，尝试启动mysqld服务。

    • 3

相关问题