[MacPorts] #16531: mysql5 secure installation

[MacPorts]

#16531: mysql5 secure installation
------------------------------------------------+---------------------------
 Reporter:  darren.weber.lists at gmail.com        |       Owner:  macports-tickets at lists.macosforge.org
     Type:  defect                              |      Status:  new                                  
 Priority:  Normal                              |   Milestone:  Port Bugs                            
Component:  ports                               |     Version:  1.6.0                                
 Keywords:  mysql install secure root password  |        Port:  mysql5 +server                       
------------------------------------------------+---------------------------
 I think we need a symbolic link for mysql in /opt/local/bin/mysql so that
 basic config scripts will work.  I guess this can screw up installation of
 multiple versions, but that can be handled by having some meta scripts to
 set the preferred alternative or current working version.  In this ticket,
 I just want to highlight that the secure installation fails because it
 cannot find the mysql command (maybe there is an easy solution for this):

 {{{
 [ dweber at elegans ~ ]$ sudo
 /opt/local/lib/mysql5/bin/mysql_secure_installation




 NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
       SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!


 In order to log into MySQL to secure it, we'll need the current
 password for the root user.  If you've just installed MySQL, and
 you haven't set the root password yet, the password will be blank,
 so you should just press enter here.

 Enter current password for root (enter for none):
 /opt/local/lib/mysql5/bin/mysql_secure_installation: line 42: mysql:
 command not found
 OK, successfully used password, moving on...

 Setting the root password ensures that nobody can log into the MySQL
 root user without the proper authorisation.

 Set root password? [Y/n]
 New password:
 Re-enter new password:
 /opt/local/lib/mysql5/bin/mysql_secure_installation: line 42: mysql:
 command not found
 Password update failed!
 [ dweber at elegans ~ ]$
 }}}

-- 
Ticket URL: <http://trac.macports.org/ticket/16531>
MacPorts <http://www.macports.org/>
Ports system for Mac OS