MySQL Forums
Forum List  »  General

Re: mysqld upgrade=FORCE with error code = 1136, error message = 'Column count doesn't match value count at row 1'
Posted by: Susan Koerner
Date: October 28, 2019 11:40AM

Hello Rob -

As Peter mentioned, the mysql.user table seems to have a different definition than expected. It looks as if it was altered or loaded from a previous version at some point. You will need to bring up the server using 8.0.17 binaries and alter the user table back to what is expected. In 8.0.17 it should have 51 columns. You can download a 8.0.17 binary version of mysql (from the community archives) and use that to bring up the mysql server in order to execute the necessary changes. To identify what the user table should look like, you can initialize a simple mysql server and examine the table.

It is also possible that other tables in the mysql schema were altered, potentially causing other issues.

I hope that this helps -

S

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.