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
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
Hope, this was of some help to you.
Thank you reading.