![MYSQL 错误:13(权限被拒绝)](https://linux22.com/image/923484/MYSQL%20%E9%94%99%E8%AF%AF%EF%BC%9A13%EF%BC%88%E6%9D%83%E9%99%90%E8%A2%AB%E6%8B%92%E7%BB%9D%EF%BC%89.png)
我收到 *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.*
答案1
我运行了以下命令,它在 Ubuntu Server 19.10 上运行良好:
sudo chown -R mysql:mysql /var/lib/mysql/
答案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
binlog
如果您手动删除文件,也可能会发生类似的错误。
- 检查
/var/log/mysql/error.log
底线,看看原因是否与binlog
文件有关。 - 如果是的,然后清除文件内容
/var/lib/mysql/binlog.index
然后重新启动 mysql 对我有帮助。