mysql56: mysql_secure_installation won't run w/o modifying PATH

[ClintO (Clint O)]

Normally when I install a port, my .profile is modified adding support for commands. When I tried to run the secure installation script, I got:

$ /opt/local/lib/mysql56/bin/mysql_secure_installation
Can't find a 'mysql' client in PATH or ./bin
Cleaning up...
Warning: Could not unlink .my.cnf.92844: No such file or directory
Warning: Could not unlink .mysql.92844: No such file or directory

I had to print the contents of the port to find out what my PATH should be. After adding it, the script worked fine.

[ryandesign (Ryan Carsten Schmidt)]

Replying to clint.olsen@…:

Normally when I install a port, my .profile is modified adding support for commands.

The only time MacPorts modifies your .profile is when you initially install MacPorts. This is intentional.

I would say that mysql_secure_installation and the other programs installed in /opt/local/lib/mysql56/bin should work without /opt/local/lib/mysql56/bin being in PATH. If they don't, that's a bug in the port, similar to #20949. It probably also affects mysql55, mysql51, mysql5, mariadb and percona.

[pixilla (Bradley Giesbrecht)]

The mysql_secure_installation script looks for mysql in ./bin and then PATH. Try this:

cd /opt/local/lib/mysql56
sudo ./bin/mysql_secure_installation

[pixilla (Bradley Giesbrecht)]

Replying to pixilla@…:

The mysql_secure_installation script looks for mysql in ./bin and then PATH. Try this:

cd /opt/local/lib/mysql56
sudo ./bin/mysql_secure_installation

clint.olsen: Did this solution work for you?

[pixilla (Bradley Giesbrecht)]

See r120590