mysql_upgrade - FATAL ERROR: Upgrade Failed

Question

I recently had my MySQL server upgraded from 5.1 to 5.5 and I'm trying to upgrade my databases using mysql_upgrade but I keep getting this error:

[root@ip-??-???-???-??? ~]# mysql_upgrade -uadmin -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed

I can't figure why this won't run. MySQL Server is running.

Try adding --verbose to the mysql_upgrade and see if that shows anything. Try doing this while the server is not running and see if that makes a difference. Related thread on sf: serverfault.com/questions/527422/… — Aziz Saleh
– Aziz Saleh, Commented Mar 21, 2014 at 16:57

user2915403 · Accepted Answer · 2014-04-24 07:18:42Z

21

I had the same issue going from MySQL 5.5 to 5.6 on OS X (installed via MacPorts).

Seems that mysql_upgrade needs to be run as user root and only root and a password needs to be set up for the user. Any other user with administrative privileges does not seem work.

So the only valid command seems to be: mysql_upgrade -u root -p

Initial solution by Chris_H at FreeBSD forums.

answered Apr 24, 2014 at 7:18

user2915403

Sign up to request clarification or add additional context in comments.

2 Comments

Groco Over a year ago

In fact, it works with other user with sufficients privileges, but you have to let the password empty. You'll have a prompt to type it after command execution.

user2915403 Over a year ago

@Groco - yes, -p implies the password prompt. So yes, might work with other administrator accounts as well provided that the password is not supplied as an argument of the execution.

GabLeRoux · Accepted Answer · 2015-05-25 19:50:58Z

8

Worked for me, but I had to use this:

mysql_upgrade --port=3306 --user=root --password=PASSWORD

I work on

mysql -V

mysql Ver 14.14 Distrib 5.5.35, for debian-linux-gnu (x86_64) using readline 6.3

edited May 25, 2015 at 19:50

GabLeRoux

18.2k17 gold badges67 silver badges83 bronze badges

answered Jun 25, 2014 at 14:05

Giuseppe Picciano

811 silver badge1 bronze badge

Comments

Aman Aggarwal · Accepted Answer · 2015-08-20 21:08:26Z

3

For my case, I need to pass my socket file location explicitly.

mysql_upgrade -S /usr/local/mysql/mysql.sock

answered Aug 20, 2015 at 21:08

Aman Aggarwal

18.6k10 gold badges55 silver badges84 bronze badges

Comments

Steve · Accepted Answer · 2014-03-26 21:47:06Z

2

If you run MySQL on a non-standard port be sure to include --port=xxxxxx

I found that skipping that can cause the error you're getting.

answered Mar 26, 2014 at 21:47

Steve

3,1753 gold badges30 silver badges49 bronze badges

Comments

Javier Crego · Accepted Answer · 2016-04-28 12:10:55Z

2

The FATAL ERROR is solved:

1º - Execute shell command: service mysqld stop

2º - Then, rename /etc/my.cnf to /etc/my.cnfbkp

3º - Execute shell command: service mysqld start

4º - Execute shell command: mysql_upgrade -u root -p YOUR_ROOT_PASSWORD

5º - Rename /etc/my.cnfbkp to /etc/my.cnf

6º - Execute shell command: service mysqld restart

edited Apr 28, 2016 at 12:10

answered Apr 22, 2016 at 22:42

Javier Crego

213 bronze badges

Comments

Tarv · Accepted Answer · 2014-06-07 13:50:41Z

0

My installation on Windows server requires port and user/pass specification.

--port=3306 --user=root --password=XXXX

edited Jun 7, 2014 at 13:50

answered Jun 1, 2014 at 16:18

Tarv

13 bronze badges

1 Comment

Tarv Over a year ago

Not sure why my comment was edited, you have to define the password after the --password switch.

user3807202 · Accepted Answer · 2014-07-05 07:09:23Z

0

Just add the configuration line to your my.cnf At the end add

[mysqlcheck] socket = /dbabcstorage/data/mysql5/mysql.sock

the correct value you can copy in the previous lines of my.cnf

answered Jul 5, 2014 at 7:09

user3807202

1

Comments

user1488459 · Accepted Answer · 2014-10-19 07:09:39Z

0

This worked for me on a CentOS/Plesk server:

mysql_upgrade -uadmin -p< /etc/psa/.psa.shadow -f

service mysqld restart

http://kb.sp.parallels.com/en/427

edited Oct 19, 2014 at 7:09

answered Oct 16, 2014 at 20:06

user1488459

112 bronze badges

1 Comment

helpse Over a year ago

Thank you. This is what I was looking for. Hope it helps someone else.

Renato Mestre · Accepted Answer · 2014-12-10 13:05:49Z

0

SOLVED!

Follow the steps as ADMINISTRATOR account:

1) Install MySQL

2) In the my.ini file, located on the MySQL path, set datadir e basedir

3) Move ALL THE CONTENT of "%MySQL%/Data" folder to the datadir above

4) Run the upgrade:

mysql_upgrade

5) Create Windows Service like this:

sc create MySQL binPath=C:/MySQL

To remove the Windows Service:

sc delete MySQL

answered Dec 10, 2014 at 13:05

Renato Mestre

364 bronze badges

Collectives™ on Stack Overflow

mysql_upgrade - FATAL ERROR: Upgrade Failed

9 Answers 9

2 Comments

Comments

Comments

Comments

Comments

1 Comment

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

9 Answers 9

2 Comments

Comments

Comments

Comments

Comments

1 Comment

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related