Running mysql_upgrade Script to Upgrade to MySQL 5.7 Fails With Message "FATAL ERROR: Upgrade failed" (Doc ID 1597323.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Symptoms

When running mysql_upgrade script, during upgrade activity from version MySQL 5.6 (or earlier) to 5.7 fails with unknown reasons (without describing the exact message)

D:\\mysql server\mysql-5.7.2-m12-winx64\bin>mysql_upgrade -uroot
Looking for 'mysql.exe' as: D:\mysql server\mysql-5.7.2-m12-winx64\bin\mysql.exe
Looking for 'mysqlcheck.exe' as: D:\mysql server\mysql-5.7.2-m12-winx64\bin\mysqlcheck.exe
FATAL ERROR: Upgrade failed

Changes

Verify from MySQL error logfile if it has Warning messages as below:

2013-11-04T09:00:55.960827Z 0 [Warning] User entry 'root'@'localhost' has an empty plugin value. The user will be ignored and no one can login with this user anymore.
2013-11-04T09:00:55.961827Z 0 [Warning] User entry 'root'@'127.0.0.1' has an empty plugin value. The user will be ignored and no one can login with this user anymore.
2013-11-04T09:00:55.963828Z 0 [Warning] User entry 'root'@'::1' has an empty plugin value. The user will be ignored and no one can login with this user anymore.
2013-11-04T09:00:55.965828Z 0 [Warning] User entry ''@'localhost' has an empty plugin value. The user will be ignored and no one can login with this user anymore.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms