第一步：在管理员命令中输入：
mysql_upgrade -u root -p --force
第二步：关闭并重启数据库
service mysql stop service mysql start
相关文章
- 01-30[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- 01-30quartz部署出现找不到表的情况,错误提示: Table 'heart_beat.QRTZ_LOCKS' doesn't exist
- 01-30Mysql报错Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- 01-30phpcms网站迁移无法更新内容提示Table 'led_com.lz_' doesn't exist的解决方法
- 01-30运行mysql时，提示Table ‘performance_schema.session_variables’ doesn’t exist
- 01-30MySQL-解决 Table'performance_schema.session_variables' doesn't exist 问题
- 01-30Mysql错误--Table 'mysql.servers' doesn't exist.
- 01-30解决mysql导入新数据库大小写问题（Table 'zup.Domain_System' doesn't exist）
- 01-30本地连接linux mysql遇到table xxx.xxx doesn't exist
- 01-30开发中运行mysql脚本，发现提示mysql提示Column count doesn't match value count at row 1错误