Location of database

[demerse]

Hi,
Silly question I guess, but how do I find out the full location of my database for putting into a script?

Thanks

[james]

What kind of script? A PHP script?

Your database host will be localhost
username will be something like cpanelusername_x,
database name will be cpanelusername_x, and password whatever you set it to.

You set up the database throught the mysql section of your cPanel.

Once you've added a database, don't forget to assign a user/password to this database.

I hope this helps.

[demerse]

Thanks James.
The script is VBScript. Yes, I've set up the database and user etc. Am running a PMachine cms on it which is working fine.

The script will import data from an XML feed into the database.
Say my domain is www.domain.com and my database name is db_name

What should I put in the script for the following?

YourDBServerName
YourDBinstanceName


Cheers

[james]

Demerse,

Please note that for security reasons, Dathorn does not allow remote access to your database directly.

You have to use a SSH tunnel - see http://forums.dathorn.com/showthread.php?t=216 for more details.

[demerse]

Yikes.. Sounds complicated


Thanks for that.