mysql56: Cannot create database at end of installation.

[murrayeisenberg@…]

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?

[carbonturtle (Michael Hosford)]

I'm having the same problem the OP describes, under OS X 10.6.8.

EDIT: I uninstalled mysql56-server and re-installed it. This time, I didn't get the first warning about being unable to write to the config file, but I still get the fatal error about not being able to find "fill_help_tables.sql". I tried specifying --basedir "/opt/local" after examining the mysql_install_db script to see how it builds the paths to the files. I also verified that "fill_help_tables.sql" exists in /opt/local/share/mysql56/ and should be readable by anybody.

Any help, hints, pointers welcome.

Thanks-- Michael

ANOTHER EDIT: Okay, operator error, sorry! I discovered a long-forgotten ~/.my.cnf that was confusing matters. I deleted it, and mysql_install_db was able to run successfully. I'll leave this comment here in case anyone else can be helped by it (my public shame notwithstanding, haha).

[pixilla (Bradley Giesbrecht)]

michael: Thank you for the feedback.
murrayeisenberg: Check mysql us picking up a my.cnf $prefix/etc/mysql56:

$ ls $(/opt/local/lib/mysql56/bin/mysqld --help --verbose 2>&1 | grep -A 1 "Default options" | sed '1d')

[mf2k (Frank Schima)]

See #57827