MySQL Upgrade Wizard should require confirmation to upgrade to 5.6 if pre 4.0 passwords are still being used
The MySQL Upgrade Wizard allows a server to be updated to mysql 5.6 while some users still have old (pre 4.0) passwords in place. This results in those database users with old passwords not being to authenticate. It's possible to determine if a user has an old or new style password by looking at the length of the password field. You could use this to get a list of all users and their password's lengths
mysql> SELECT user, Length(Password) FROM mysql.user;
The user's with a length of 16 are using the pre 4.0 passwords, and the users with 41 are using new, secure passwords.
Downgrades to mysql are not supported and since http://bugs.mysql.com/bug.php?id=69027 seems to be about the configuration option to allow those old passwords to authenticate not working, there does not appear to be an easy way to recover from this situation.
Therefore, my request is that the MySQL Upgrade Wizard check for old passwords once upgrading to 5.6 is selected. If old passwords are found, it should inform the user about the situation and require that they click a button before proceeding.