Last Tuesday I found an issue a still did not found in which mysql was not starting. Looking at the logs showed this logs:<\/p>\n
Fatal error: Can\u2019t open and lock privilege tables: Can\u2019t find file: \u2018host\u2019 (errno: 2)<\/pre>\nOk, so what should we do now? Well, case you had (something I would recommend to backups for \/var\/lib\/mysql you could restore \/var\/lib\/mysql\/mysql<\/p>\n
If not, do not worry, you’re still not lost (or not too much)<\/p>\n
First you have to manage to run mysql, even without such table. for doing so just run:<\/p>\n
mysqld_safe --skip-grant-tables<\/pre>\nSo now mysqld is running, and now? just use the sql command restore:<\/p>\n
mysql\nmysql> use mysql\nmysql> REPAIR TABLE host ;<\/pre>\nMany times this command won’t be working so you can still use:<\/p>\n
mysql> REPAIR TABLE host USE_FRM;<\/pre>\nOnce done this. restart your mysqld and you will be up and running!<\/p>\n","protected":false},"excerpt":{"rendered":"
Last Tuesday I found an issue a still did not found in which mysql was not starting. Looking at the logs showed this logs: Fatal error: Can\u2019t open and lock privilege tables: Can\u2019t find file: \u2018host\u2019 (errno: 2) Ok, so…<\/p>\n