First remote web site attempt

Hi,

I have a programming background but am new to the web, it has also been a while since I did sql. Here is what I have done:

I created a website using the feedback tutorial in Dreamweaver. It worked fine locally. I uploaded the files to my remote server but the dbase stuff didn’t upload. I get fatal sql error when run from the remote site. Assuming I needed to mirror the dbase on the remote serve I did just that, creating a remote dbase. Now I need to know how to connect to this remote database.

I have the information on the remote dbase,

name: myUsername_databaseName

username: myUsername_sqluUserName

I created a user with all privileges.

Here are my issues:

I think I need to use user/password to access the remote database.

I assume that I need to path to the remote server but the hosting company seems to be saying that I just need user/password for access. Do I go into the sql server-side code on my php pages created in Dreamweaver and change the current /localhost pathing to the remote path and user/password? Can I do it from the database panel entries rather than hunting for the actual code?

Any help would be appreciated! It feels I am making it harder than it is.