ERROR 2002 (HY000): Can't connect to local MySQL server

Question

在Ubuntu机器上出现"mysql"命令错误:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld。袜子"(111)

服务未启动，出现以下错误:

root@bettorssidekick:/# service mysql start
start: Job failed to start
root@bettorssidekick:/#

重新启动服务，它不会再运行了。以下是mysql日志的最终日志条目:

110824 12:03:36 [Note] Plugin 'FEDERATED' is disabled.
110824 12:03:36  InnoDB: Initializing buffer pool, size = 8.0M
110824 12:03:36  InnoDB: Completed initialization of buffer pool
110824 12:03:36  InnoDB: Started; log sequence number 0 44233
110824 12:03:36 [Note] Event Scheduler: Loaded 0 events
110824 12:03:36 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.54-1ubuntu4'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
110902  5:34:04 [ERROR] /usr/sbin/mysqld: Disk is full writing './bettorssidekick/schedules.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to contin$
110902  5:34:04 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110902  5:36:02 [ERROR] /usr/sbin/mysqld: Disk is full writing './bettorssidekick/cronejob.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continu$
110902  5:36:02 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
110902  5:44:04 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs

Answer 1

110902  5:34:04 [ERROR] /usr/sbin/mysqld: Disk is full writing ...

问题:硬盘已满

解决方案:删除一些文件

Answer 2

我尝试了不同的方法，从不同的来源获得指示。然而，我刚刚改变了交通规则，然后它就为我工作了。确定你的规则是什么，比如ssh, http，自定义tcp规则，RDB之类的。

Answer 3

请查看下面的URL，这将帮助您解决您的问题。

MySQL ERROR (HY000)

此链接将向您详细说明为什么会产生此错误以及如何解决此问题。