can't start mysql56 after move datadir

[Murray Eisenberg]

Since I cannot get mysql server to run, from

  /opt/local/lib/mysql56/bin/mysqladmin variables | grep socket

I obtain output:

  /opt/local/lib/mysql56/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/opt/local/var/run/mysql56/mysqld.sock' (61)'
Check that mysqld is running and that the socket: '/opt/local/var/run/mysql56/mysqld.sock' exists!

The same thing happens if I try to execute "sudo port load mysql56-server". Evidently mysql is never starting with my non-default datadir location.

> On 13 Feb2015, at 3:30 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)
> 
> You should be able to find the socket path with:
> /opt/local/lib/mysql56/bin/mysqladmin variables | grep socket
> 
> 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