Opened 11 years ago

Closed 10 years ago

#40606 closed defect (fixed)

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

Reported by: ClintO (Clint O) Owned by: pixilla (Bradley Giesbrecht)
Priority: Normal Milestone:
Component: ports Version: 2.2.0
Keywords: Cc:
Port: mysql56

Description

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.

Change History (4)

comment:1 in reply to:  description Changed 11 years ago by ryandesign (Ryan Carsten Schmidt)

Cc: pixilla@… openmaintainer@… removed
Owner: changed from macports-tickets@… to pixilla@…
Port: mysql56 added; databases/mysql56 removed
Summary: mysql_secure_installation won't run w/o modifying PATHmysql56: mysql_secure_installation won't run w/o modifying PATH

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.

comment:2 Changed 11 years ago by 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

comment:3 in reply to:  2 Changed 11 years ago by 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?

comment:4 Changed 10 years ago by pixilla (Bradley Giesbrecht)

Resolution: fixed
Status: newclosed

See r120590

Note: See TracTickets for help on using tickets.