Today morning I got call from development team about MySQL as the MySQL service is not getting started so checked error.log file and the error was as below
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Error itself indicates some issue with MySQL database (system database) has issue so applied below command and issue resolved
# mysql_install_db --user=mysql --basedir=/usr/ --ldata=/var/lib/mysql/
Pre-caution:- it will reset all user accounts (will delete all users from MySQL) only root user will be there with blank password.
The problem was interesting and the solution was more interesting so I feel to document it.