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
as the error itself says Please use mysql_upgrade to fix this error.
So, I fired the command which gave me below output
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