[MacPorts] #47831: mysql56-server @5.6.24_0 Documentation Issue

[MacPorts]

#47831: mysql56-server  @5.6.24_0 Documentation Issue
-----------------------------+-----------------------
  Reporter:  gwong@…         |      Owner:  pixilla@…
      Type:  defect          |     Status:  new
  Priority:  Low             |  Milestone:
 Component:  ports           |    Version:  2.3.3
Resolution:                  |   Keywords:
      Port:  mysql56-server  |
-----------------------------+-----------------------

Old description:

> Prior to "sudo -u _mysql mysql_install_db" there needs to be:
>
> chown -R _mysql:_mysql /opt/local/etc/mysql56/
>
> This may be only applicable to Yosemite (I'm on v10.10.3) but it already
> noted in another ticket, https://trac.macports.org/ticket/44978 , and at
> http://serverfault.com/questions/543725/cant-start-mysql-5-6-installed-
> via-macports-on-os-x-10-8-5-new-install-errno .
>
> {{{
>   WARNING: Could not write to config file /opt/local/etc/mysql56/my-
> new.cnf: Permission denied
> }}}
>
> This is the warning you get as part of the port install, but then you run
> into ERROR when running "sudo -u _mysql mysql_install_db"
>
> As more and more users are on Yosemite, this may become more important.
> Thanks! Gary

New description:

 Prior to "sudo -u _mysql mysql_install_db" there needs to be:

 {{{
 chown -R _mysql:_mysql /opt/local/etc/mysql56/
 }}}

 This may be only applicable to Yosemite (I'm on v10.10.3) but it already
 noted in another ticket, #44978, and at
 http://serverfault.com/questions/543725/cant-start-mysql-5-6-installed-
 via-macports-on-os-x-10-8-5-new-install-errno .

 {{{
   WARNING: Could not write to config file /opt/local/etc/mysql56/my-
 new.cnf: Permission denied
 }}}

 This is the warning you get as part of the port install, but then you run
 into ERROR when running "sudo -u _mysql mysql_install_db"

 As more and more users are on Yosemite, this may become more important.
 Thanks! Gary

--

Comment (by ryandesign@…):

 > Prior to "sudo -u _mysql mysql_install_db" there needs to be:
 >
 > {{{
 > chown -R _mysql:_mysql /opt/local/etc/mysql56/
 > }}}

 That should not be necessary. The mysql56-server port already creates that
 directory with the correct ownership. The only reason that should be
 necessary is if you had created the directory manually with the wrong
 ownership before installing the port.

-- 
Ticket URL: <https://trac.macports.org/ticket/47831#comment:2>
MacPorts <https://www.macports.org/>
Ports system for OS X