mysql56: Cannot create databases

[Murray Eisenberg]

On 12 Sep 2014 21:02:03 -0400, Murray Eisenberg <murrayeisenberg at gmail.com> wrote:

> 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?
> 
> (I submitted ticket, too.)

I _think_ the problem was conflicting settings in existing my.cnf files from a native MySQL installation (from mysql.com), in /private/etc and /usr/local/mysql-5.6.20-osx10.8-x86_64. After renaming those, uninstalling mysql56-server, and reinstalling, I was able to execute the mysql_install_db script without warning or error.

---
Murray Eisenberg		murrayeisenberg at gmail.com
503 King Farm Blvd #101		Home (240)-246-7240
Rockville, MD 20850-6667	Mobile (413)-427-5334