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
![ERROR 1558 (HY000): Column count of mysql.user is wrong mysql version](http://rohutech.com/wp-content/uploads/2019/03/2.png)
![ERROR 1558 (HY000): Column count of mysql.user is wrong mysql login command](http://rohutech.com/wp-content/uploads/2019/03/8.png)
as the error itself says Please use mysql_upgrade to fix this error.
So, I fired the command which gave me below output
![ERROR 1558 (HY000): Column count of mysql.user is wrong mysql_upgrade to fix this error.
ERROR 1558 (HY000): Column count of mysql.user is wrong](http://rohutech.com/wp-content/uploads/2019/03/7-edited.png)
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