无法登录到MYSQL出现错误错误2002 (HY000)：无法通过套接字'/var/lib/ MySQL /mysql.sock‘连接到本地mysql服务器(2)

Question

我无法连接到mysql服务器出现错误

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

我已经检查了日志：

InnoDB: Apply batch completed
130820  5:19:41  InnoDB: Error: the OS said file flush did not succeed
130820  5:19:41  InnoDB: Operating system error number 5 in a file operation.
InnoDB: Error number 5 means 'Input/output error'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html
InnoDB: File operation call: 'flush'.
InnoDB: Cannot continue operation.
130820 05:19:42  mysqld ended

由于这个原因，我无法重新启动或启动mysql

[root@OPX-VPC-DB-Report-Slave-2 ~]# service mysqld status
mysqld is stopped
[root@OPX-VPC-DB-Report-Slave-2 ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]
[root@OPX-VPC-DB-Report-Slave-2 ~]#

我在网上搜索了很多次，但没有找到任何解决方案。

我已配置RAID 0并装载/mnt目录和symlinc

# ln -s /mnt/mysql_data/   /usr/lib/mysql
# ln -s /mnt/mysql_run     /var/run/mysql

昨天有一个复制崩溃了，所以我运行了

SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;

同样，复制也是正常的

请帮我解决问题

我的配置详情是:"-

Fedora 6 and mysql 5.0.2

Please help this is my production DB 

Answer 1

这似乎是权限问题，尝试使用setenforce 0禁用selinuza，然后重新启动mysql服务，同时检查mysql在挂载设备上是否具有正确的权限(假设您是以root或mysql无法访问的sudo用户身份挂载的)