Monthly Archives: October 2014

[SOLVED] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist

Dear All,

 

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.

 

Thanks,

 

 Prashant Deshpande

Advertisements

1 Comment

Filed under Uncategorized