Description:
I was upgrading from 5.1.25-bk to 6.0.6-bk and observed the following:
After the upgrade mysqld during startup would print a number of messages like the following:
080429 16:42:04 [ERROR] Incorrect definition of table mysql.db: expected the type of column 'Event_priv' at position 20 to have character set 'utf8' but found character set 'utf8mb3'.
The messages were about various columns in mysql.db and mysql.event tables.
I ran mysql_upgrade script, it successfully finished, and the messages about mysql.db went away. The messages about mysql.event remained though, I still get this:
080429 16:42:26 [ERROR] Incorrect definition of table mysql.event: expected the type of column 'db' at position 0 to have character set 'utf8' but found character set 'utf8mb3'.
080429 16:42:26 [ERROR] Incorrect definition of table mysql.event: expected the type of column 'definer' at position 3 to have character set 'utf8' but found character set 'utf8mb3'.
080429 16:42:26 [ERROR] Incorrect definition of table mysql.event: expected the type of column 'comment' at position 15 to have character set 'utf8' but found character set 'utf8mb3'.
080429 16:42:26 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
How to repeat:
install 5.1
install 6.0
start the server, note the error messages
run mysql_upgrade script
start the server, note the error messages
Suggested fix:
make mysql_upgrade handle mysql.event table also.