MySQL does not start and it’s given, the output is “Terminated”,
#/etc/init.d/mysql start
MySQL Starting . . . . . . . . . . . Terminated
MySQL Starting . . . . . . . . . . . Terminated
Then, when look into mysql error log file generated below error,
# tail –f /var/log/mysql.log
MySQL error 1033 incorrect information in file mysql
MySQL error 1033 incorrect information in file mysql
If are you using WHM/cPanel can see the mysql error in /var/lib/mysql/host.hostname.com.err
Solution:
# cd /var/lib/mysql/
# ls | grep ib_logfile
ib_logfile0
ib_logfile1
# ls | grep ib_logfile
ib_logfile0
ib_logfile1
Rename both files ib_logfile0 and ib_logfile1 and try to start again,
/etc/init.d/mysql stop
mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak
mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak
# /etc/init.d/mysql start
Comments (0)