Upgrading MySQL ... don't forget to run mysql_upgrade

[Mark Hattam]

Just in case this helps anybody ...

I've just noticed in my
    /opt/local/var/db/mysql5/<host>.err
file, these lines on every startup.

/opt/local/libexec/mysqld: Table 'mysql.plugin' doesn't exist
091210 14:57:44 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
091210 14:57:44 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
091210 14:57:44 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50140, now running 50141. Please use mysql_upgrade to fix this error.
091210 14:57:44 [ERROR] mysql.user has no `Event_priv` column at position 29
091210 14:57:44 [ERROR] Cannot open mysql.event
091210 14:57:44 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

so I ran
sudo  /opt/local/lib/mysql5/bin/mysql_upgrade -uroot -p<password>
and it succeded in accomplishing the needed upgrade tasks.


Next one to fix (sometime) is
091210 14:57:43 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.


Mark