Hello.
[email protected] [/var/lib/mysql]# service mysql status
MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]
[email protected] [/var/lib/mysql]#
[email protected] [/var/lib/mysql]# tail -f hostname.err
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.h tml
InnoDB: for how to resolve the issue.
140507 0:02:06 InnoDB: Waiting for the background threads to start
140507 0:02:07 InnoDB: 5.5.36 started; log sequence number 70702761909
140507 0:02:07 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140507 0:02:07 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140507 0:02:07 [Note] Server socket created on IP: '0.0.0.0'.
140507 0:02:07 [ERROR] /usr/sbin/mysqld: Table './mysql/db' is marked as crashe d and should be repaired
140507 0:02:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/db' is marked as crashed and should be repaired
140507 00:02:07 mysqld_safe mysqld from pid file /var/lib/mysql/hostname.pid ended
/var/lib/mysql/hostname.pid not found!
[email protected] [/var/lib/mysql]# service mysql start
Starting MySQL....The server quit without updating PID file (/var/lib/mysql/hostname.pid).
in cPanel :
The MySQL server is currently offline.
Error while connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). Error from MySQL query: Can't call method "do" on an undefined value at /usr/local/cpanel/Cpanel/Mysql.pm line 1196, <STDIN> line 1.
please help.
- - - Updated - - -
[email protected] [/var/lib/mysql]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[email protected] [/var/lib/mysql]# service mysql status
MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]
[email protected] [/var/lib/mysql]#
[email protected] [/var/lib/mysql]# tail -f hostname.err
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.h tml
InnoDB: for how to resolve the issue.
140507 0:02:06 InnoDB: Waiting for the background threads to start
140507 0:02:07 InnoDB: 5.5.36 started; log sequence number 70702761909
140507 0:02:07 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140507 0:02:07 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140507 0:02:07 [Note] Server socket created on IP: '0.0.0.0'.
140507 0:02:07 [ERROR] /usr/sbin/mysqld: Table './mysql/db' is marked as crashe d and should be repaired
140507 0:02:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/db' is marked as crashed and should be repaired
140507 00:02:07 mysqld_safe mysqld from pid file /var/lib/mysql/hostname.pid ended
/var/lib/mysql/hostname.pid not found!
[email protected] [/var/lib/mysql]# service mysql start
Starting MySQL....The server quit without updating PID file (/var/lib/mysql/hostname.pid).
in cPanel :
The MySQL server is currently offline.
Error while connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). Error from MySQL query: Can't call method "do" on an undefined value at /usr/local/cpanel/Cpanel/Mysql.pm line 1196, <STDIN> line 1.
please help.
- - - Updated - - -
[email protected] [/var/lib/mysql]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)