connection testing

[amo]

Hi

My problem is this....

When i upload my php page it tells me it can't connect to my database. However when running the site from my PC (localhost) no such error appears. How can i check if the database connection is working whilst running the site from my PC???

Many thanks😃

[Drakla]

Where is the database hosted? What type is it?

If you've got a duplicate on your local and remote servers are your connection details the same?

Need input.

[amo]

well thats the maing thing

I have been unable to upload my database to where my website is hosted. So i know that my online website wont connect to the database at the moment. The database is also located on my PC (localhost) and i want to test the php coding so how can i connect my offline site to the offline database??

Is that what you need to know??

[Drakla]

So you've got your database and scripts on a remote server - have you set up any users to access the database?

Have you got cpanel or anything that allows you to set up grants on the database? If so it would be just a case of changing or recreating the connection script.

[bradgrafelman]

Database? Are we talking about MySQL?

Check your privilige tables; how are you connecting? Is the username you're using in the remote script granted as "username@%" or "username@localhost" ? Big difference 🙂

Again, though, are we talking about a MySQL database connection?

$conn = @mysql_connect('yourip', 'user', 'pass') or die('error connecting!<br>mysql said: ' . mysql_error());