Re: Having trouble Connecting to multiple instances on remote server

[Barry Galbraith]

How are you trying to connect?

sh> mysql -h host.name.com -P 3306 -u user -p

Should get you a request for user's password on the "normal" instance.
Use a different Port number for the other instances.

sh> mysql -h host.name.com -P 3307 -u user -p

sh> mysql -h host.name.com -P 3308 -u user -p

Make sure the ports are open in the firewall on the machine that has the mysql servers running on it.

Good luck,
Barry.



Edited 1 time(s). Last edit at 03/21/2013 05:35PM by Barry Galbraith.