mysql - 无法通过套接字 '/var/lib/mysql/mysql.sock' (2) 连接到本地 MySQL 服务器。 mysql.sock 不存在于/var/lib/mysql/中

Question

Magento 显示“处理您的请求时出错”

尝试命令“sudo service mysqld restart”但启动失败

然后看到日志显示“SQLSTATE[HY000] [2002] 没有这样的文件或目录”

我在 Google、stackoverflow、magento stackoverflow 网站上进行了很少的搜索，最后得到了一些可能的内容

在命令“mysqld -u root -p status”之后

显示“mysqladmin:连接到“localhost”服务器失败错误:'无法通过套接字'/var/lib/mysql/mysql.sock'连接到本地MySQL服务器(2)'检查 mysqld 是否正在运行并且套接字:“/var/lib/mysql/mysql.sock”是否存在!

我发现/var/lib/mysql/中没有 mysql.sock 所以现在我应该做什么。我不是专家，只是新手。不幸的是，我向 ec2 实例中的所有目录授予了 777 权限，在此问题发生一段时间后，我看到我的网站“处理您的请求时出错。出于 ec2 安全原因，我无法使用 ftp 或 ssh 访问实例。所以我必须创建新实例将此 EBS 提供给新实例，更改权限后我能够访问我的实例

请查看我的 my.cnf 文件。我发现有些东西可以提供帮助

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mysqld according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

这是 mysqld.log

/usr/libexec/mysql55/mysqld: Can't create/write to file '/tmp/ibmCz4dv'     (Errcode: 13)
160212 18:29:37  InnoDB: Error: unable to create temporary file; errno: 13
160212 18:29:37 [ERROR] Plugin 'InnoDB' init function returned error.
160212 18:29:37 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE   failed.
160212 18:29:37 [ERROR] Unknown/unsupported storage engine: InnoDB
160212 18:29:37 [ERROR] Aborting
160212 18:29:37 [Note] /usr/libexec/mysql55/mysqld: Shutdown complete
160212 18:29:37 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

775 到/tmp 以及现在的 mysqld.log

775 到/tmp 和 mysqld.log

/usr/libexec/mysql55/mysqld: Can't create/write to file '/tmp/ibLzshr1' (Errcode: 13)
160213  9:08:59  InnoDB: Error: unable to create temporary file; errno: 13
160213  9:08:59 [ERROR] Plugin 'InnoDB' init function returned error.
160213  9:08:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160213  9:08:59 [ERROR] Unknown/unsupported storage engine: InnoDB
160213  9:08:59 [ERROR] Aborting

160213  9:08:59 [Note] /usr/libexec/mysql55/mysqld: Shutdown complete

160213 09:08:59 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

请帮我整理一下

Answer 1

mysql用户显然没有权限在/tmp中创建文件

/usr/libexec/mysql55/mysqld: Can't create/write to file '/tmp/ibmCz4dv'     (Errcode: 13)

检查/tmp的访问权限，应该是777。顺便说一句，系统“errno 13”是“权限被拒绝”

据此，服务器停止并且不会创建任何套接字，从而导致连接错误。