Cannot start MySQL
- by Mohamed Nour El-Din
I used this command from shell to repair all Databases
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
and after that I restarted the server
when it came back alive again I tried to open my vBulletin forum but I recived Database error message.
and also tried to open phpMyAdmin but I received this error :
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured).
I checked the services list and found that the MySQL Service is not listed, so I tried to start it from shell I receive this error :
Starting MySQL.Manager of pid-file quit without updating fi[FAILED]
could anyone help me in that ?
thanks in advance.
update
I found these lines in the log file
101101 01:36:01 mysqld started
101101 1:36:01 [Warning] Asked for 196608 thread stack, but got 126976
101101 1:36:01 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and last (automatic?) repair failed
101101 1:36:01 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and last (automatic?) repair failed
101101 1:36:01 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and last (automatic?) repair failed
101101 01:36:01 mysqld ended
What should I do then ?
