[MacPorts] #44978: mysql56: Cannot create database at end of installation. (was: mysql56-server: Cannot create database at end of installation.)

[MacPorts]

#44978: mysql56: Cannot create database at end of installation.
--------------------------------+-----------------------
  Reporter:  murrayeisenberg@…  |      Owner:  pixilla@…
      Type:  defect             |     Status:  new
  Priority:  Normal             |  Milestone:
 Component:  ports              |    Version:  2.3.1
Resolution:                     |   Keywords:
      Port:  mysql56            |
--------------------------------+-----------------------
Changes (by ryandesign@…):

 * cc: pixella@… (removed)
 * keywords:  installation =>
 * owner:  macports-tickets@… => pixilla@…
 * port:  mysql56-server @5.6.19_1 => mysql56


Old description:

> I installed  mysql56-server @5.6.19_1 under OS X 10.9.4.
>
> Following instructions at https://trac.macports.org/wiki/howto/MAMP, I
> executed:
>
>    sudo port select mysql mysql56
>
>    sudo -u _mysql /opt/local/lib/mysql56/bin/mysql_install_db   [NOT
> "_db5"]
>
> Result:
>
>   WARNING: Could not write to config file /opt/local/etc/mysql56/my-
> new.cnf: Permission denied
>
>   FATAL ERROR: Could not find /fill_help_tables.sql
>
> I tried doing "chown _mysql:_mysql /opt/local/etc/mysql56/my-new.cnf",
> which did cure the first error.
>
> However, the 2nd error persist.
>
> In fact, after updating the located, an mdfind reveals:
>
>    mdfind -name fill_help_tables.sql
>    /opt/local/share/mysql56/fill_help_tables.sql
>
> So how should this be fixed?

New description:

 I installed  mysql56-server @5.6.19_1 under OS X 10.9.4.

 Following instructions at wiki:howto/MAMP, I executed:

 {{{
    sudo port select mysql mysql56
    sudo -u _mysql /opt/local/lib/mysql56/bin/mysql_install_db   [NOT
 "_db5"]
 }}}

 Result:

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

 I tried doing "{{{chown _mysql:_mysql /opt/local/etc/mysql56/my-
 new.cnf}}}", which did cure the first error.

 However, the 2nd error persist.

 In fact, after updating the located, an mdfind reveals:

 {{{
    mdfind -name fill_help_tables.sql
    /opt/local/share/mysql56/fill_help_tables.sql
 }}}

 So how should this be fixed?

--

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