Bug #8530 Errors Duplicate entry 'localhost-root' for key 1 on rpm install

• Submitted: 16 Feb 2005 3:34
• Modified: 18 Feb 2005 21:29
• Reporter: Bernard Treine
• Status: Can't repeat
• Category: MySQL Server: Installing
• Severity: S1 (Critical)
• Version: 4.1.9-0
• CPU Architecture: Any

[16 Feb 2005 3:34] Bernard Treine

Description:
Downloaded MySQL-server-4.1.9-0.i386.rpm
installed on Redhat 9:
#rpm -ivh MySQL-server-4.1.9-0.i386.rpm
warning: MySQL-server-4.1.9-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
   1:MySQL-server           ########################################### [100%]
050216 17:50:23 [Warning] Asked for 196608 thread stack, but got 126976
050216 17:50:24 [Warning] Asked for 196608 thread stack, but got 126976
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

End of output.

PLEASE also change to lower case your package names as nobody will find these on their system using rpm -qa | grep mysql. You shot yourselves in the foot there.

How to repeat:
Please refer to the above.

Suggested fix:
I don't know.