Elena Stepanova added a comment - 2014-10-31 17:49 - edited 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): stop server; start server with skip-grant-tables; run mysql_upgrade; stop server; start server normally. 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 revno: 4336 revision-id: sergii@pisem.net-20140806112744-qb444e3qz83564db fixes bug: https://mariadb.atlassian.net/browse/MDEV-6535 committer: Sergei Golubchik <sergii@pisem.net> branch nick: 10.0 timestamp: Wed 2014-08-06 13:27:44 +0200 message: MDEV-6535 Ordering of mysql_upgrade tasks is not optimal first update system tables, then the rest 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.

Sergei Golubchik added a comment - 2014-11-10 14:32 - edited elenst , Isn't this the same with 5.6? They also run run_sql_fix_privilege_tables() before upgrading user tables and it also includes flush privileges .

Elena Stepanova added a comment - 2014-11-10 16:55 Maybe, I can check it if it helps. But mysql_upgrade_service only exists in MariaDB, so whatever they run, I doubt it works exactly the same way. Maybe they don't rely on anonymous access but use some kind of a service account, like our deb packages do. Or maybe they don't run it at all and leave it to the user to do it manually.

Andriy added a comment - 2014-11-18 11:34 Any delivery date defined?

Sergei Golubchik added a comment - 2014-11-18 12:51 It's fairly high priority (was Blocker, even though I've just downgraded it to Critical). Normally it means that it will be in the next 10.0 release (see http://mariadb.org/jira for the release schedule).