Opened 13 years ago

Closed 12 years ago

#14600 closed defect (fixed)

MySQL5-server fixes

Reported by: paulbeard@… Owned by: ryandesign (Ryan Schmidt)
Priority: Normal Milestone:
Component: ports Version: 1.6.0
Keywords: Cc: jyrkiwahlstedt
Port: mysql5, mysql5-devel

Description

  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.

  1. 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

Change History (5)

comment:1 Changed 13 years ago by jmroot (Joshua Root)

Owner: changed from macports-tickets@… to ryandesign@…

Assigning to maintainer.

comment:2 Changed 12 years ago by ryandesign (Ryan Schmidt)

Cc: jwa@… added
Port: mysql5 mysql5-devel added
Status: newassigned

The mysql_secure_installation issue has a duplicate #16531.

comment:3 Changed 12 years ago by ryandesign (Ryan Schmidt)

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

comment:4 Changed 12 years ago by (none)

Milestone: Port Bugs

Milestone Port Bugs deleted

comment:5 in reply to:  description Changed 12 years ago by ryandesign (Ryan Schmidt)

Resolution: fixed
Status: assignedclosed

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

Note: See TracTickets for help on using tickets.