CocaoMySQL on OSX lets you connect to remote mysql servers.
The error I get is:
"Connection failed!
Unable to connect to host [my hostingrails IP address].
Be sure that the address is correct and that you have the necessary privileges.
MySQL said: Access denied for user '[my hr username]'@'[my ISP IP]' (using password: YES)"
A reverse lookup of "my ISP IP" shows it belongs to my ISP (Hughes Network Systems satellite), though I didn't recognized it, and it's different from what I get at http://whatismyipaddress.com
The connection settings they offer, and values I tried are:
Host: [my hostingrails IP]
User: [my hostingrails username as used in cpanel]
Password: [as used in cpanel]
[x] Use SSH tunnel
SSH Host: [my hostingrails IP]
SSH User: [my hostingrails username as used in cpanel]
SSH Password: [as used in cpanel]
Local Port: 8888 [this was the default]
In cpanel mysql I now have the following Access Hosts
%
[IP found at http://whatismyipaddress.com]
[xx.xx.% using the digits from ISP IP]
[ISP IP]
localhost
This isn't critical, I can use phpmyadmin but would be nice to get it working.
