MYSQL错误: 13 (权限被拒绝)
MYSQL错误: 13 (权限被拒绝)
提问于 2020-04-20 14:33:38
我正在获得* mysql.service的作业失败，因为控制进程与错误代码退出。
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.*回答 3
Ask Ubuntu用户
回答已采纳
发布于 2020-04-20 14:55:07
我运行了以下命令，它在Ubuntu 19.10上工作：
sudo chown -R mysql:mysql /var/lib/mysql/Ask Ubuntu用户
发布于 2021-01-13 04:51:45
您可以登录到/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服务。
Ask Ubuntu用户
发布于 2023-01-03 19:08:04
如果手动删除binlog文件，也可能发生类似的错误。
- 检查
/var/log/mysql/error.log以查看底线，如果原因与binlog文件有关。 - 如果是，那么清除文件
/var/lib/mysql/binlog.index的内容，然后重新启动mysql帮助我。
页面原文内容由Ask Ubuntu提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://askubuntu.com/questions/1228827
复制相关文章
相似问题
腾讯云开发者
