在Ubuntu机器上的问题“mysql”命令上获得此错误:
ERROR 2002(HY000):无法通过套接字'/var/run/mysqld/mysqld.sock'连接到本地MySQL服务器(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
3 回答
请检查以下网址,以帮助您解决问题 .
MySQL ERROR 2002 (HY000)
此链接将向您显示详细信息为何会生成此错误以及如何解决此问题 .
我尝试了不同的方式,我得到了不同来源的指示 . 但是,我只是改变了交通规则,然后它为我工作 . 确保你所特定的规则是什么,ssh,http,自定义tcp规则,RDB之类的 . 如果您确定然后修复规则,否则打开所有流量 .
问题:您的硬盘已满
解决方案: Delete some files