I am running MySQL Ver 14.14 Distrib 5.5.57 on Debian Jessie (x86_64). In my mysql.users table, I have a custom column added for database owner id--which is for my server management system's use. Somewhere along the way, MySQL started to complain when I try to modify a user's privileges:
ERROR 1547 (HY000): Column count of mysql.user is wrong. Expected 42, found 43. The table is probably corrupted
The first 42 columns are exactly as MySQL expects. The 43rd about which it is complaining is my added column. How can I tell MySQL that it's "OK" for there to be 43 columns?
And yes, I have run the appropriate upgrade scripts with each upgrade to MySQL, including one extra time "just to make sure":
mysql_upgrade --force -uroot -p
Thanks in advance for any assistance!