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

13 Sep 2014

      #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