Re: mysqld upgrade=FORCE with error code = 1136, error message = 'Column count doesn't match value count at row 1'

[Susan Koerner]

Hi Rob -

Yes, you are using the binaries that I indicated, but, it seems that the server already progressed far enough through the upgrade process and the datadir believes that it is 8.0.18. If you had removed columns from the users table, the internal upgrade process could have fixed that. If you added columns, then you would get the scenario and failure that you see.

One suggestion is to try start the server using the 8.0.18 binaries using both --upgrade=minimal and --skip-grant-tables. This should make the server start without ACL. Once started, you could cleanup the user table, and restart the server to complete the upgrade. You may want to check other tables in the mysql schema to be sure that there were no other manual changes.

I hope that this helps -

S