Hiya,
Yes - it looks as though we even use the same web hosting providers (UKServers)!
Here is what my code looks like: (I have left out my password and changed some details):
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "localhost";
$database_localhost = "uks66xxx";
$username_localhost = "uks66xxx";
$password_localhost = "XXXXXXXX";
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);
?
This is the final configuration that will be uploaded to the web server.
My connection for my local machine testing server is similar:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "localhost";
$database_localhost = "mydatabase";
$username_localhost = "root";
$password_localhost = "mypassword";
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);
?>
If you are with UKServers, and if you use the default provided database settings, your database and username will probably both be uks47018 and the password is likely to be the same as your control panel login; but if you created a new database or new user, they will be appended by a suffix (i.e. uks47018newdb uks47018newuser).
If in doubt about your password, go to your control panel and create a new user and password.
Post back if you need more help!