#16531: mysql5 secure installation ------------------------------------------------+--------------------------- Reporter: darren.weber.lists@gmail.com | Owner: macports-tickets@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@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@elegans ~ ]$ }}} -- Ticket URL: <http://trac.macports.org/ticket/16531> MacPorts <http://www.macports.org/> Ports system for Mac OS