Re: Having trouble Connecting to multiple instances on remote server

[Chris Isaksen]

This will happen even on the loacl server.

connecting to instance #2

shell> mysql -p --port 3307

will get the error "Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock'

but if I use this command

shell> mysql -p --port 3307 --protocol tcp it works just fine.


Stupid me - the firewall was the culprit for the remote session, I noramlly turn it off for testing.
thanks



Edited 1 time(s). Last edit at 03/22/2013 06:36AM by Chris Isaksen.