mgjj 发表于 2019-1-27 12:46:21

Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't ex

  

Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
  启动mysql
  Starting MySQL.Manager of pid-file quit without updating fi[失败]
  查看日志 /var/lib/mysql/localhost.err
Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
最终解决方法如下:
在mysql的安装目录下,我的是/usr/local/mysql
./usr/bin/mysql_install_db   --usrer=mysql--datadir=/var/lib/mysql
原因是重装的时候数据目录不一致导致
然后再次启动,OK
  




页: [1]
查看完整版本: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't ex