MySql path, can't find or connect to it

[tvg]

I have a site, I have the database, I can't get them to connect?

I am working in dreamweaver and trying to set up a testing server from hostgator servers so I can test it locally before I upload...

I can't find the database? Where is it on the server and how do I connect?

I need help please, this is the first time I've tried to work with mysql and php on a host server other than my local computer.

Thank you

[Tomer]

First you need to create a database/user via cPanel -> MySQL Databases.

Second you need to connect to the database via PHP script:

PHP Code:

 <?php
 
 // Connect.
 mysql_connect($host, $user, $pass)
 or die ("Couldn't connect to database.");
 
 // Select database.
 mysql_select_db($database)
 or die ("Couldn't select database.");
 
 // Execute query...
 $result = mysql_query("query");
 
 ?>

You will need to define the variables. Note that $host will usually be localhost.

Good luck