Hi there
I bought me some dreamweaver template which require to set up a mySQL database on the server. I just followed their tutorial step by step but when I entered the database info and then try to open it, the following message appears:

Warning: mysql_connect(): Access denied for user: 'kktrad2@quasor.lunarpages.com' (Using password: YES) in /home/kktrad2/public_html/monohawaiishop/vsadmin/db_conn_open.php on line 14
You need to set your database connection in vsadmin/db_conn_open.php.

The database info I entered in the file vsadmin/db_conn_open.php looks as follow:

$db_username = "kktrad2_tom";  // Your database login username
$db_password = "password";  // Your database login password
$db_name = "kktrad2_monohawaii";      // The name of the database you wish to use
$db_host = "localhost";   // The address of the database. Often this is localhost, but may be for example db.yoursite.com

I double checked and the info is exactly on how it shows on the cPanel.

No clue on what is wrong.

Any suggestions are very much appreciated.

Cheers

Wow, that was a quick response - I am impressed - many thanks.

What I did is I opened a user called kktrad2_tom (somehow the kktrad2 was already there, so it must be that there are now 2 users having acccess). Anyway, I quickly copied on what I can see on the mySQL page:


Users in monohawaii
kktrad2_tom (Privileges: ALL PRIVILEGES)

Connection Strings

Perl
$dbh = DBI->connect("DBI:mysql:kktrad2_monohawaii:localhost","kktrad2_tom","<PASSWORD HERE>");

PHP
$dbh=mysql_connect ("localhost", "kktrad2_tom", "<PASSWORD  HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("kktrad2_monohawaii");

just recreated the user once more and double checked the password - it is correct.
Tried access with Safari (MAC) and Internet Explorer by enterning the following information (according tutorial):

http://www.kktrading.com/monohawaiishop/createdb.php

again, the same message appears
Warning: mysql_connect(): Access denied for user: 'kktrad2@quasor.lunarpages.com' (Using password: YES) in /home/kktrad2/public_html/monohawaiishop/vsadmin/db_conn_open.php on line 14
You need to set your database connection in vsadmin/db_conn_open.php.

you were right - I changed it to the kktrad2 user name to see if this worked - which didn't.

BUT THANKS - after setting up the account once more it finally worked, the database has been installed.

Cheers - you helped me a lot - I am truly impressed at the service of you and LUNAR - great response time. They all promise it - but you deliver !!!! THANKS

Priest man your a quick one I tell YOU!