进入mysql提示错误:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[root@localhost ~]# /usr/local/mysql/bin/mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/mysql/tmp/mysql.sock' (2)
查看日志:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
100430 5:34:25 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
^G/usr/local/mysql/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
100430 5:34:25 [ERROR] Aborting
100430 5:34:25 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
100430 05:34:25 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
解决方法:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
进入my.cnf(我的路径是/etc/my.cnf)
查找:skip-locking 更改为:skip-external-locking . 至此解决一个问题,但是mysql还是不能正常启动!
看到错误日志里面的 File './mysql-bin.index' not found 提示了吧?找不到mysql-bin.index ,但是我看了下我./mysql/var/目录下面是有 mysql-bin.index 的,这就可能是权限的问题了。那就修改var文件组及目录权限吧!
chgrp -R mysql var/
chown -R mysql var/
OK,问题解决了,启动mysql: service mysql start
linux下面mysql突然不能启动了,先查看一下日志文件,不知道mysql日志文件在哪,先看一下mysql的配置文件:
# vim /etc/my.cnf
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
default-character-set=utf8
可知mysql的日志文件在/var/log/mysqld.log里面,打开看看:
Can't start server: can't create PID file: No space left on device
可知是没有足够的空间导致mysql服务不能启动。
转自:http://qiliuping.blog.163.com/blog/static/10238293201191345133627/
mysql无法启动,报错 Can't start server: can't create PID file: No space left on device
最近在维护linux服务器时发现,网站打不开了,经过检查发现是mysql数据库宕掉了,死活就是启动不起来。
然后看mysql日志文件
出现Can't start server: can't create PID file: No space left on device
这个错误。
提示磁盘空间不足
后用df -h 命令查看
竟然发现磁盘容量全部用完了,于是要查看是谁占用了
用命令:
find /tmp -size +100000000c
查找下磁盘中大于100M的文件
竟然出现:
tomcat的日志文件占用了443G,真是可恶啊啊
rm -rf catalina.out
重新启动mysql即可。
最好重启linux os。
在Linux下我所遇到mysql不能启动的问题!