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
Post a Comment