ERROR 1558 (HY000): Column count of mysql.user is wrong - Guy in front of laptop stressed up
ERROR 1558 (HY000): Column count of mysql.user is wrong - Photo by Sebastian Herrmann on Unsplash

ERROR 1558 (HY000): Column count of mysql.user is wrong

This article covers a complete solution to the below 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.

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 your information – 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
mysql version
mysql login command
mysql login command

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

So, I fired the command which gave me below output

mysql_upgrade to fix this error.
ERROR 1558 (HY000): Column count of mysql.user is wrong
sudo mysql_upgrade

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

Just to conclude, in this type of error, often expected & found number will be different but the solution which I have posted will be the same.

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

Other Popular writings from the blog

About the author

Rohan Kamble

A Web Developer by profession, who loves the web to the core with over 9 Years of Experience working on a wide range of domains like websites on e-commerce, Travel, Alumni, matrimonial, company's professional sites, Finance, company internal communications and many more. Also WordPress Plugins & Chrome extensions.

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.