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:
None 
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
Description:
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
Bye
[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
/usr/local/mysql/bin/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
owners.

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
/usr/bin
[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
...

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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.