My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.