首页 > 数据库 > mysql > 正文

#1805 - Column count of mysql.user is wrong. Expected 43, found 42. The table is
2018-01-24 10:44:15   来源:   评论:0 点击: 收藏

mysql创建用户报错:#1805 - Column count of mysql.user is wrong. Expected 43, found 42. The table is probably corru...
mysql创建用户报错:

#1805 - Column count of mysql.user is wrong. Expected 43, found 42. The table is probably corrupted




原因:
升级完mysql后未使用mysql_upgrade升级数据结构造成的。

解决方法:

find / -name "mysql_upgrade"         #查找mysql_upgrade所在目录



/usr/local/mysql/bin/mysql_upgrade -uroot -p 123456     #这是以我的mysql_upgrade所在位置为例,密码修改成自己的

相关热词搜索:1805 Column count of mysql

上一篇:Clipping Path King Int
下一篇:最后一页

评论排行