[bug-notifications] [mysql5 0004798]: mysql_secure_installation returns error with current mysql5 package

[Mantis Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://www.opencsw.org/mantis/view.php?id=4798 
====================================================================== 
Reported By:                AirOnSkin
Assigned To:                
====================================================================== 
Project:                    mysql5
Issue ID:                   4798
Category:                   packaging
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
====================================================================== 
Date Submitted:             2011-06-30 11:45 CEST
Last Modified:              2011-09-21 14:02 CEST
====================================================================== 
Summary:                    mysql_secure_installation returns error with current
mysql5 package
Description: 
After installing mysql5 and running mysql_secure_installation the script
breaks at the second action (removing anonymous user) because the first
action (setting the root password) doesn't work. The new root password
doesn't get applied (even if the output says so), hence the script has no
rights for the second action.

After typing the new root password twice the following appears (full log
attached):

Reloading privilege tables..
/opt/csw/mysql5/bin/sparcv9/mysql_secure_installation: !: not found
====================================================================== 

---------------------------------------------------------------------- 
 (0009292) AirOnSkin (reporter) - 2011-09-21 14:02
 https://www.opencsw.org/mantis/view.php?id=4798#c9292 
---------------------------------------------------------------------- 
maciej's guess was right. When downloading the mysql-5.0.87 source, there's
a file called scripts/mysql_secure_installation.sh which calls /bin/sh.

The function (see here: http://paste.pocoo.org/show/479787/) that changes
the root password uses ! at two points. The thing that doesn't actually
work is reloading the privileges and since there's not check if that was
successful no error is being displayed (instead the script happily shouts
"Password updated successfully!")

Either one changes the script to use another shell instead or the code
needs to be edited to work with sh.