错误2002(HY000):无法通过套接字'/var/run/mysqld/mysqld.sock'连接到本地MySQL服务器(111)

问题描述:

在Ubuntu计算机上的问题"mysql"命令中获取此错误:

Getting this error on issue "mysql" command on Ubuntu machine:

ERROR 2002(HY000):无法通过套接字'/var/run/mysqld/mysqld.sock'(111)连接到本地MySQL服务器

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

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

The service is not starting with following error:

root@bettorssidekick:/# service mysql start

start: Job failed to start

root@bettorssidekick:/#

重新启动服务,它将不会再次运行.这是mysql日志中的最终日志条目:

Restarted the service and it wont run again. Here is the final log entries from mysql log:

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

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

问题:您的硬盘已满

解决方案:删除一些文件