MySQL5-server fixes

[paulbeard@…]

1. It would help if permissions were set properly so MySQL could create its socket file in /opt/local/var/db/mysql5.

chown -R mysql:mysql /opt/local/var/db/mysql5

For whatever reason mysqld could create and write to a log file but couldn't create its socket file until I set the permissions.

2. On line 42 of /opt/local/lib/mysql5/bin/mysql_secure_installation mysql should be mysql5.

     40 do_query() {
     41     echo $1 >$command
     42     mysql5 --defaults-file=$config <$command

[jmroot (Joshua Root)]

Assigning to maintainer.

[ryandesign (Ryan Carsten Schmidt)]

The mysql_secure_installation issue has a duplicate #16531.

[ryandesign (Ryan Carsten Schmidt)]

The mysql_secure_installation issue has been fixed in r39951 (for mysql5) and r39952 (for mysql5-devel).

[(none)]

Milestone Port Bugs deleted

[ryandesign (Ryan Carsten Schmidt)]

Replying to paulbeard@…:

1. It would help if permissions were set properly so MySQL could create its socket file in /opt/local/var/db/mysql5.

I cannot explain why your /opt/local/var/db/mysql5 directory was not owned by mysql:mysql; it should be, since the mysql5 port has contained code to create the directory with that ownership since r13929.

Note that the socket file does not usually go there; the socket file is supposed to go in /opt/local/var/run/mysql5