1044: Access denied for user: '@localhost' to database 'dc_surveyDB'

[threnody77]

hi!

hav a problem w/ connecting to a MySQL db.

the error msg is:
1044: Access denied for user: '@' to database 'dc_surveyDB'

my code snippet is:
<?
$GLOBALS["maindsn"] = "dc_surveyDB";
$GLOBALS["username"] = "dc_user@localhost";
$GLOBALS["password"] = "";
//establish connection
$GLOBALS["dbLink"] = @mysql_connect("localhost", $GLOBALS["username"], $GLOBALS["password"]);
$s = mysql_select_db($GLOBALS["maindsn"], $GLOBALS["dbLink"]);

echo mysql_errno().": ".mysql_error()."<BR>";

        if ($s) print('OK...');
        else pint('ERROR..');

?>

any idea why there's an error? any help would be greatly appreciated...

🙂

[TTT]

first of all .. don't use @mysql_connect, it suppress the error message.

try
mysql_pconnect

[[deleted]]

Never use pconnect unless you are running your own server, is uses quite a lot of resources and will cause problems on shared servers.

The username does not include the hostname, it should be only 'dc_user'.