第一步：在管理员命令中输入：
mysql_upgrade -u root -p --force
第二步：关闭并重启数据库
service mysql stop service mysql start
相关文章
- mysql5.5 报Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- mysql 提示表不存在的解决方法error: 1146: Table doesn‘t exist
- 开发中运行mysql脚本，发现提示mysql提示Column count doesn't match value count at row 1错误
- 'mysql.column_stats' doesn't exist and Table 'mysql.index_stats' doesn't exist
- 解决mysql插入数据报错[Err] 1146 - Table 'performance_schema.session_status' doesn't exist
- [jnhs]hibernate只能创建一张/表不创建表com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kaihu.t_client_info' doesn't exist和org.hibernate.exception.SQLGrammarException: could not execute statement
- message Request processing failed; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.answer' doesn't exist
- Mysql报错Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- 在使用phpmyadmin时，数据库总报错#1146 - Table ‘phpmyadmin.pma_table_uiprefs' doesn't exist
- windows下 Mysql 错误1067 Can't open and lock privilege tables: Table 'mysql.user' doesn't exist