Hi,
Okay, so I have two hosting services. One on GoDaddy.com and one on Ipower.com. The scripts I have running don't work on the godaddy database setup but they do with the ipower database. Hence my problem.
So, now I'm trying to figure out how I can connect to the ipower database from the godaddy scripts.
Can anyone help with this one?
How do I connect to a database on another host?
Moderator: General Moderators
Re: How do I connect to a database on another host?
i think you need to contact your hosts at ipower as they will need to set up permissions for an external connection.
Hope that helps
Hope that helps
Re: How do I connect to a database on another host?
In mysql_connect() (or whichever other function you're using), you can specify the hostname. You'll also have to set up your database to allow connections from hosts other than localhost.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Re: How do I connect to a database on another host?
Thanks, I really appreciate the help. I actually contacted the two different hosts and neither one of them allows a remote database connection. LOL. Thats soooooo garbage! Thanks anyway!
Re: How do I connect to a database on another host?
Do they allow you to use SSH shell? If yes, then you may use SSH tunneling...
There are 10 types of people in this world, those who understand binary and those who don't