can't start mysql56 after move datadir

[Murray Eisenberg]

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 mysql-fabric-doctrine-1.4.0.zip).  And in ~/ there is _no_ file .my.cnf but no my.cnf.


> On 13 Feb2015, at 3:18 PM, Bradley Giesbrecht <pixilla at macports.org> wrote:
> 
> 
> On Feb 12, 2015, at 5:24 PM, Murray Eisenberg <murrayeisenberg at gmail.com> 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 gmail.com
503 King Farm Blvd #101		Home (240)-246-7240
Rockville, MD 20850-6667	Mobile (413)-427-5334