首页 > 数据库技术 > 详细

ERROR 2002 (HY000) Can’t connect to local MySQL server through socket ‘var mysql 启动不了

时间:2015-11-10 14:18:05      阅读:386      评论:0      收藏:0      [点我收藏+]

今天在启动myql时候突然报了一个这个错误,感觉非常的奇怪,mysql可以启动一会,mysql.sock又消失了,找了很多方法,有可能:1,磁盘空间不足 2,目录权限不够

查看一下错误日志,终于看出问题

2015-11-10 10:28:56 23732 [Note] InnoDB: 5.6.15 started; log sequence number 385737380720
2015-11-10 10:28:56 23732 [Note] Recovering after a crash using mysql-bin
2015-11-10 10:28:56 23732 [Note] Starting crash recovery...
2015-11-10 10:28:56 23732 [Note] Crash recovery finished.
2015-11-10 10:28:58 23732 [Note] Server hostname (bind-address): ‘0.0.0.0‘; port: 3306
2015-11-10 10:28:58 23732 [Note]   - ‘0.0.0.0‘ resolves to ‘0.0.0.0‘;
2015-11-10 10:28:58 23732 [Note] Server socket created on IP: ‘0.0.0.0‘.
2015-11-10 10:28:59 23732 [Warning] ‘proxies_priv‘ entry ‘@ root@ts‘ ignored in --skip-name-res
olve mode.
2015-11-10 10:28:59 23732 [Note] Event Scheduler: Loaded 8 events
2015-11-10 10:28:59 23732 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: ‘5.6.15-log‘  socket: ‘/usr/local/mysql/mysql.sock‘  port: 3306  Source distribution
151110 10:29:27 mysqld_safe Number of processes running now: 0
151110 10:29:27 mysqld_safe mysqld restarted
2015-11-10 10:29:28 24038 [Note] Plugin ‘FEDERATED‘ is disabled.
2015-11-10 10:29:28 24038 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 10:29:28 24038 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-11-10 10:29:28 24038 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 10:29:28 24038 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 10:29:29 24038 [Note] InnoDB: Initializing buffer pool, size = 64.0M
2015-11-10 10:29:29 24038 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 10:29:29 24038 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 10:29:29 24038 [Note] InnoDB: The log sequence numbers 299946710457 and 299946710457
 in ibdata files do not match the log sequence number 385737380730 in the ib_logfiles!
2015-11-10 10:29:29 24038 [Note] InnoDB: Database was not shutdown normally!


“The InnoDB memory heap is disabled”表明有可能是mysql不正常关闭造成的,解决方法:

解决办法:
删除掉
ibdata* ,
ib_logfile* ,
所有的日志。
重启后可启动数据库,因数据库是非正常关闭引起的。所有会造成数据丢失。 要做好备份工作

本文出自 “广州linux运维” 博客,请务必保留此出处http://milenovo.blog.51cto.com/10554394/1711329

ERROR 2002 (HY000) Can’t connect to local MySQL server through socket ‘var mysql 启动不了

原文:http://milenovo.blog.51cto.com/10554394/1711329

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!