ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 50560, now running 50643. Please use mysql_upgrade to fix this error.

When I tried to create a user in MySQL server, I got this error

ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42.  Created with MySQL 50560, now running 50643. Please use mysql_upgrade to fix this error.

Just for FYI – I am using MySQL version 5.6.43
To clear the confusion between mysql version and distribution refer below link
https://stackoverflow.com/questions/8645184/version-vs-distrib-number-of-mysql

mysql version
  • Save
mysql version
  • Save

as the error itself says Please use mysql_upgrade to fix this error.

So, I fired the command which gave me below output

sudo mysql_upgrade
  • Save
sudo mysql_upgrade

Finally, I was able to create a user identified by a password and give its access to a database

Hope, this was of some help to you.
Thank you reading.

About the author

Rohan Kamble

I am a Web Developer by profession, who loves the web to the core with over 8 Years of Experience on working a wide range of domains like websites on e-commerce, matrimonial, company’s professional sites, Finance, company internal communications and many more…

View all posts

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.