mysql.sock 111_mysql启动失败:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.so...

请不要到网上找前篇一律复制的东西，同一篇文章可能是上千人看都不看一眼的采集下去我实验次数不下50遍了，要是能解决不在这里提问以前好好的，今天打开网站提示：ERROR2002(HY000):C...

请不要到网上找前篇一律复制的东西，同一篇文章可能是上千人看都不看一眼的采集下去

我实验次数不下50遍了，要是能解决不在这里提问

以前好好的，今天打开网站提示：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

查看mysql日志看到今天日志：

140526 13:40:23 InnoDB: Initializing buffer pool, size = 8.0M

140526 13:40:23 InnoDB: Completed initialization of buffer pool

InnoDB: The log sequence number in ibdata files does not match

InnoDB: the log sequence number in the ib_logfiles!

140526 13:40:23 InnoDB: Database was not shut down normally!

InnoDB: Starting crash recovery.

InnoDB: Reading tablespace information from the .ibd files...

InnoDB: Restoring possible half-written data pages from the doublewrite

InnoDB: buffer...

140526 13:40:23 InnoDB: Started; log sequence number 0 44233

140526 13:40:23 [ERROR] /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 13)

140526 13:40:23 [ERROR] Can't start server: can't create PID file: Permission denied

140526 13:40:23 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

linux是centos mysql这些是通过yum安装的，能解决万谢

展开