Mysql login page issues

[kfc]

I know this may sound quite easy but I have been having trouble creating a login/ join page for my site using mysql.
I have tried several scripts but none work. I think I might be filling in the connect to database incorrectly.
Any ideas on what I should be putting here?--

<?php
// Connects to your Database
mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error());
mysql_select_db("Database_Name") or die(mysql_error());

I'm not sure what I should put for the fields especially host address and password. Im not sure whether Its the cpanel password.

Please can someone help me out with that piece of code.

[felgall]

The username and password that go there are ones you created specifically for the database using the database options in cPanel.

[Kraxsis]

One common problem I have seen is people forgetting to assign the database user to the actual databse. Also as far as "your.hostaddress.com" use localhost. Please don't use your cpanel password, mainly for the reason if you ever change your cpanel password, you will then need to hunt down all your files you used it in, despite having your cpanel password stored in a document on your account.