Hi ! I am facing the Following error while trying to access my mysql DB
mysql> grant all privileges on octobercmsdb.* to 'octoberuser'@'localhost' identified by 'password' with grant option;
ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 50560, now running 50642
How to solve this issue?
This is because the database was created with the oldest release of mysql so you need to upgrade the MYSQL
to latest version
you can use mysql_upgrade command to fix this error
#mysql_upgrade --force -uroot -p
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Running 'mysql_fix_privilege_tables'...
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
OK
Now it will work.
