mysql56: Cannot create databases

[Bradley Giesbrecht]

On Sep 13, 2014, at 12:07 PM, Murray Eisenberg <murrayeisenberg at gmail.com> wrote:

> 
> 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.

Correct, mysql will pull settings from various places:
http://dev.mysql.com/doc/refman/5.6/en/option-files.html


Regards,
Bradley Giesbrecht (pixilla)

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 455 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <https://lists.macosforge.org/pipermail/macports-users/attachments/20140915/0248211e/attachment.sig>