mysql.user的列数错误.预期为42，发现为44.该表可能已损坏 [英] Column count of mysql.user is wrong. Expected 42, found 44. The table is probably corrupted

问题描述

当前，我正在使用最新版本的ISPConfig3.今天，我想添加一个数据库和用户.没用然后我在PHPmyadmin上尝试了它，但是没有用.

Currently I'm using the newest version of ISPConfig 3. Today I wanted to add a db and user. It didn't work. Then I tried it on PHPmyadmin and it didn't work.

当我尝试在PHPMyadmin用户面板中添加用户时，收到以下错误消息:

When I tried to add a user in PHPMyadmin Users Panel I received the following error message:

您的SQL语法有错误；检查手册 对应于您的MySQL服务器版本以使用正确的语法 在第1行的'* TO'test'@'localhost''附近

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* TO 'test'@'localhost'' at line 1

/var/log/mysql/error.log的输出:

The output from /var/log/mysql/error.log:

[ERROR] mysql.user的列数错误.预期为42，发现为44. 该表可能已损坏

[ERROR] Column count of mysql.user is wrong. Expected 42, found 44. The table is probably corrupted

Mysql版本:5.5.55-0 + deb8u1 PHPMyadmin版本:4:4.2.12-2 + deb8u2

Mysql Version: 5.5.55-0+deb8u1 PHPMyadmin Version: 4:4.2.12-2+deb8u2

Debian Linux 8

Debian Linux 8

推荐答案

在Debian 8(jessie)中将mysql服务器从5.5更新到5.7时，我遇到了同样的问题.在极少数情况下，如果直接绕过版本序列进行更新，则可能会发生这种情况. (许多人都这样做，但是官方不支持这种升级). 就我而言，当我执行以下命令时，它运行良好:

I had the same problem when I updated the mysql server from 5.5 to 5.7 in Debian 8 (jessie). In rare cases, it probably happens if you update directly bypassing the sequences of versions. (Many people do this, but such upgrades are not officially supported). In my case, it worked fine when I executed the command below:

mysql_upgrade --force -uroot -p

我希望这会对您有所帮助

I hope this will help you

这篇关于mysql.user的列数错误.预期为42，发现为44.该表可能已损坏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！