[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

前几天我把自己测试机器的mysql data目录下的文件全删除了。

启动数据库报错：

[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

解决办法：

运行mysql_install_db。

如：

/usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data