[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-07-07 13:25 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
====================================================================== 

---------------------------------------------------------------------- 
 (0009186) AirOnSkin (reporter) - 2011-07-07 13:25
 https://www.opencsw.org/mantis/view.php?id=4798#c9186 
---------------------------------------------------------------------- 
I've tested the issue on a freshly installed solaris and uploaded the log
file (mysql-secure-install-extended.log).

My experience:
* There are 3 scripts on the system, they all behave the same.
* All operations except setting the password work. If you start the script
and choose to not change the root pw all other steps complete
successfully.
* When executing the script after a couple of minutes after I tried to
change the root password (see try1-try3 in the log file) the script does
not accept the default password (which is empty upon mysql installation)
anymore. Instead the password I wanted to change the default to is being
used (see try4 in the log file). Very strange oO

I hope that helps.

Cheers,
Stefan