mysql.host不存在_mysql启动提示mysql.host 不存在,启动失败的解决方法

图示:

d8e0ad9e6e600e701bc387ca4f66e26e.png

日志:

190625 10:48:42 InnoDB: Started; log sequence number 0 130207

190625 10:48:42 [ERROR] Fatal error: Can‘t open and lock privilege tables: Table ‘mysql.host‘ doesn‘t exist

190625 10:48:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

190625 10:48:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

190625 10:48:57 [Warning] /usr/libexec/mysqld: Option ‘--set-variable‘ is deprecated. Use --variable-name=value instead.

190625 10:48:58 InnoDB: Initializing buffer pool, size = 8.0M

190625 10:48:58 InnoDB: Completed initialization of buffer pool

InnoDB: The log sequence number in ibdata files does not match

InnoDB: the log sequence number in the ib_logfiles!

190625 10:48:58 InnoDB: Database was not shut down normally!

InnoDB: Starting crash recovery.

InnoDB: Reading tablespace information from the .ibd files...

InnoDB: Restoring possible half-written data pages from the doublewrite

InnoDB: buffer...

190625 10:48:58 InnoDB: Started; log sequence number 0 130207

190625 10:48:58 [ERROR] Fatal error: Can‘t open and lock privilege tables: Table ‘mysql.host‘ doesn‘t exist

190625 10:48:58 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

1d2cd83fec71859dcc292de6ce933e45.png

方法:

一个命令搞定,不要在网上去乱抄,没用

cd /etc/

mysql_install_db

3ae766180cfad095b335c4da5a5efb67.png

如果,我的方法给你解决了难题,请关注本blog

排错:

mysqld --help --verbose

如果配置文件有错,会在这里面报出来。。。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值