#1805 - Column count of mysql.user is wrong. Expected 43, found 42. The table is
2018-01-24 10:44:15 点击：

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