CMD 进入MYSQL的安装目录..Bin 下
执行
mysql_upgrade -u root -p --force
输入密码..然后等待一会儿..会跑一些东西..然后重启服务
相关文章
- mysql Column count doesn't match value count at row 1
- Mysql报错Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- mybatis向mysql数据库中插入数据报错Field 'id' doesn't have a default value
- 安装mysql 出现：Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- MySql重装以后，修改数据库路径，打开以前的数据库报Table 'XX库.XX表' doesn't exist错误的解决办法
- MySQL中执行sql语句错误 Error Code: 1093. You can't specify target table 'car' for update in FROM clause
- 帝国CMS Table '***.phome_ecms_news_data_' doesn't exist
- MySQL之Field‘***’doesn’t have a default value错误解决办法
- MySql报错： You can't specify target table 'table name' for update in FROM clause解决办法
- MYSQL之You can't specify target table for update in FROM clause解决办法