Help - Search - Members - Calendar
Full Version: SQL Remote Access
InsanelyMac Forum > Discuss and Learn > Internet(s), Servers, and Networks
djet
So I'm trying to connect to an SQL database run by another person and I seem to be failing miserably.....

My account is set up to connect and everything with permissions and the host set as wildcards, but when I try to connect i get the "IP @ ISP" is not authorized to connect to there. I was going to try to set it up using SSH, but I'm not sure I want to try to guesswork my way to get it working on his PC. Does anyone here know how to do it or know a good guide for doing it?
~pcwiz
1) Make sure host name is correct
2) Make sure database name is correct
3) Make sure username and password are correct
4) Make sure that the remote host is set to allow remote connections
5) Make sure that some sort of software or hardware firewall isn't blocking your access attempt (check that on both your computer and the remote computer hosting the database)
djet
Got it!

Somehow the hostard set it up to host on local host, not his IP....
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.