problem connection to hosting server

royalbi

Hi all,
Could someones please help me answering the query i got related to connection to database located in a hosting server ( ie. tripod. lycos.com)?

I am working on a web project which works perfectly fine on my localhost. But when upload to other hosting servers ( i tried different servers ) I received messages telling me that i dont have access to the database located in the server.

I have seen many sample code used to connect to a database at a hosting server, but no matter how I changed the code, it still failed. I would appreciate very much if someone could help me solving this issue.

Say if my user name is royalbi
password is funnyone
the host server is http://www.tripod.lycos.com
database name : royalbi_db
what will be the correct syntax for db connection?
Many thanks in advance 🙂

trexx

i guess there's no need to do a change in the connect-function. all you have to do is find out on which server the database is hosted. "localhost" works fine on your machine, but most providers won't let you access the localhost due to security issues.
just change the server in your live environment. (it may be something like "db.lycos.com:3306" e.g., but you should really check the documentation of your hosting-provider to be sure about that).
it's also possible, that the name of your DB on the live server is not the same as the name of your dev-DB.

royalbi

Thanks for your reply trexx.

I've checked my DB name on the server and the DB name on the code to connect db. It's correct.

most providers won't let you access the localhost due to security issues.
just change the server in your live environment. (it may be something like "db.lycos.com:3306"

I'm not sure what you meant by that. Did you mean that "db" stands for the database name i was given by hosting provider, OR should it be the site name i was allocated for?

I'm still stuck with the connection problem. Please help.

trexx

no, i meant that the server name you have to provide in mysql_connect may not be "localhost". in your develpoment environment you may connect with:

mysql_connect( 'localhost', 'myname', 'mypwd' );

but your hosting-provider may have the databases hosted elsewhere, maybe on another port too (my own provider does that e.g.) so you would have to connect by

mysql_connect( 'databases.yourprovider.com:6001', 'myname', 'mypwd' );