database - Unable to login to MYSQL getting error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) -


i not able connect mysql server getting error

error 2002 (hy000): can't connect local mysql server through socket '/var/lib/mysql/mysql.sock' (2) 

i have checked log :-

innodb: apply batch completed 130820  5:19:41  innodb: error: os said file flush did not succeed 130820  5:19:41  innodb: operating system error number 5 in file operation. innodb: error number 5 means 'input/output error'. innodb: operating system error numbers described @ 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 

due not able restart or start mysql

[root@opx-vpc-db-report-slave-2 ~]# service mysqld status mysqld stopped [root@opx-vpc-db-report-slave-2 ~]# /etc/init.d/mysqld start timeout error occurred trying start mysql daemon. starting mysql:                                            [failed] [root@opx-vpc-db-report-slave-2 ~]# 

i have searched lot on internet not found solution

i have configured raid 0 , mount /mnt directory , symlinc

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

yesterday there replication crashed have ran

set global sql_slave_skip_counter=1; 

and again replication fine

please resolve problem

my configuration details :"-

fedora 6 , mysql 5.0.2  please production db  

it seems permission issue, try disabling selinuza using setenforce 0, restart mysql service, check if mysql has right permissions on mounted device (assuming mounted root or sudo user mysql cannot access)


Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -