Column count of mysql.user is wrong. Expected 42, found 44. The table is probably corrupted
mysql
Solution
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
Problem
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. When I tried to add a user in PHPMyadmin Users Panel I received the following error message: 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 The output from /var/log/mysql/error.log: [ERROR] Column count of mysql.user is wrong. Expected 42, found 44. The table is probably corrupted Mysql Version: 5.5.55-0+deb8u1 PHPMyadmin Version: 4:4.2.12-2+deb8u2 Debian Linux 8