Bug #59339 after upgraded to 5.5.8 , ran mysql_upgrade, got FATAL ERROR: Upgrade failed
Submitted: 6 Jan 2011 20:11 Modified: 6 Jan 2011 21:47
Reporter: steven tang Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S1 (Critical)
Version:MySQL 5.5.8 OS:Linux (mysqlcheck: unknown option '--fix-db-names')
Assigned to: CPU Architecture:Any

[6 Jan 2011 20:11] steven tang
After upgraded to MySQL 5.5.8 and then ran mysql_upgrade as suggested by MySQL, I got following FATAL ERROR: Upgrade failed

[root@dev80 data]# mysql -uroot -p<p> -hdev80
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.5.8-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit
[root@dev80 data]# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: unknown option '--fix-db-names'
FATAL ERROR: Upgrade failed

How to repeat:
just ran the utility
[6 Jan 2011 20:43] Valeriy Kravchuk
Are you sure that mysql_upgrade from proper version, 5.5.8, is called? Please, send the results of:

which mysql_upgrade

Linux command.
[6 Jan 2011 20:48] steven tang
[root@dev80 data]# which mysql_upgrade

[root@dev80 data]# mysql_upgrade --help
mysql_upgrade  Ver 1.1 Distrib 5.5.8, for linux2.6 (x86_64)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

MySQL utility for upgrading databases to new MySQL versions.
[6 Jan 2011 20:59] Valeriy Kravchuk
Please, send the results of:

mysqlcheck --version
[6 Jan 2011 21:10] steven tang
Found the problem: in somehow under /usr/bin/, there also some mysql stuff:

[root@dev80 bin]# pwd
[root@dev80 bin]# dir mysql*
-rwxr-xr-x 1 root root 314568 May 27  2010 mysql*
-rwxr-xr-x 1 root root 110776 May 27  2010 mysqlaccess*
-rwxr-xr-x 1 root root  35144 May 27  2010 mysqladmin*
-rwxr-xr-x 1 root root 112944 May 27  2010 mysqlbinlog*
-rwxr-xr-x 1 root root  30576 May 27  2010 mysqlcheck*
-rwxr-xr-x 1 root root   7632 May 27  2010 mysql_config*
-rwxr-xr-x 1 root root  75184 May 27  2010 mysqldump*
-rwxr-xr-x 1 root root   3245 May 27  2010 mysql_find_rows*
-rwxr-xr-x 1 root root  26160 May 27  2010 mysqlimport*
-rwxr-xr-x 1 root root  28224 May 27  2010 mysqlshow*
-rwxr-xr-x 1 root root  14473 May 27  2010 mysql_tableinfo*
-rwxr-xr-x 1 root root 112136 May 27  2010 mysql_waitpid*
[root@dev80 bin]# del mysql*

Now the mysql_upgrade has been run properly.

[root@dev80 bin]# mysql_upgrade -hdev80 -p<p> 
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--host=dev80' 
Running 'mysqlcheck' with connection arguments: '--host=dev80' 
mysql.columns_priv                                 OK
mysql.db                                           OK

[6 Jan 2011 21:47] Valeriy Kravchuk
Good news. The problem was, probably, not a result of any bug in 5.5.8...