Bug #75723 Ensure 5.7 supports smooth live upgrade from 5.6
Submitted: 2 Feb 2015 11:12 Modified: 17 Mar 2015 15:26
Reporter: Georgi Kodinov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S3 (Non-critical)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[2 Feb 2015 11:12] Georgi Kodinov
Description:
The upgrade procedure from 5.6 to 5.7 should be :
1. stop the 5.6 server.
2. upgrade the binaries
3. run the 5.7 server over the 5.6 server's database with *no* special options
4. run 5.7's version of mysql_upgrade
5. restart the server.

Nothing more, nothing less.

How to repeat:
Try the above

Suggested fix:
Make sure the changes we did to the semantics of the mysql.user.plugin, mysql.user.password and mysql.user.authentication string support the above scenario.
Add special cases and support of the 5.6 data file layout as needed.
[17 Mar 2015 15:26] Paul DuBois
Noted in 5.7.6 changelog. Implemented by WL#8350.