Quote:
Originally Posted by Doug G
Just a note, for any remote mysql management tool to work you'll have to make sure mysql itself allows access from your remote client computer, and that the firewall and any routhers on the mysql server allows mysql connections.
|
Good advice.
Personally I use Navicat on my windows desktop to administer a number of MySQL servers, some on the local subnet and most in data centers.
Navicat allows a connection to be defined to create an SSH tunnel from the Windows desktop to the remote server, thus using the "localhost" configuration for access, also means not having to open external access unless it's absolutely necessary.