I have done numerous LAMP stack installation and had no issue with MySQL until recently. Upon checking with the mysqld.log file, it seems my storage engine db init function returned error.
I’m not sure what would caused the issue here, but it seems my findings suggested that the mysql/data files that has something to do with the issue. Reading the log file points that the ib_logfile0 has different size.
So, since the mysqld is already at stopped, I just delete the following files:
Using the following command to remote the files:
sudo rm /var/lib/mysql/data/ib*
Hope others find the article useful.