Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 10.0.14
-
Fix Version/s: 10.0.15
-
Component/s: Platform Windows
-
Labels:None
-
Environment:Windows 8.1 x64
Description
Can't migrate from MySQL 5.6.21 to MariaDB 10.0.14. Wizard (or commad line tool) on Phase 5 throws FATAL ERROR code 1 (and no logs created).
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Thanks for the report.
The problem itself is generic, but it's most visible on Windows due to the specific upgrade process.
Here is how mysql_upgrade_service works (skipping irrelevant details):
It runs the server with skip-grant-tables, so it doesn't need to care about valid username/password, which it has nowhere to take from.
It worked fine till recently. But starting from the following revision
things changed. Now mysql_upgrade starts by fixing privilege tables, which ends with FLUSH PRIVILEGES (it used to be run at the end). After that, when next steps are attempted, they can't be executed because privilege checks are back in place, while mysql_upgrade and its children don't use a valid account.