can't start mysql56 after move datadir

Murray Eisenberg murrayeisenberg at
Fri Feb 13 12:34:59 PST 2015

I don't think I have another my.cnf.  I see:

   /opt/local/lib/mysql56/bin/mysqld --help --verbose 2>&1 | grep -A 1 "Default options" | tail -n +2
/etc/my.cnf /etc/mysql/my.cnf /opt/local/etc/mysql56/my.cnf ~/.my.cnf 

However, in /etc (actually, /private/etc) there's a file my.cnf~ but _no_ my.cnf. In /etc/mysql there's no file whatsoever even with "my.cnf" as part of its name (just fabric.cfg and  And in ~/ there is _no_ file .my.cnf but no my.cnf.

> On 13 Feb2015, at 3:18 PM, Bradley Giesbrecht <pixilla at> wrote:
> On Feb 12, 2015, at 5:24 PM, Murray Eisenberg <murrayeisenberg at> wrote:
>> I should add that whereas the command "sudo port load mysql56-server" runs without returning any error to the terminal, the next command, beginning "/opt/local/lib/mysql56/bin/mysql" bombs out, returning the error:
>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql56/mysqld.sock' (61)
> Do you have another my.cnf file being read before /opt/local/etc/mysql56/my.cnf:
> /opt/local/lib/mysql56/bin/mysqld --help --verbose 2>&1 | grep -A 1 "Default options" | tail -n +2
> Regards,
> Bradley Giesbrecht (pixilla)

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

More information about the macports-users mailing list