need help with msg Error 1044

[mikewooten]

i'm working with php code and uploading my pages on to my server and i keep getting this message.

Error: 1044: Access denied for user 'xxxx@localhost' to database 'yyyy'

x - is the name i use to log into my database
y - is my database name

how can it be fixed so that my page will be able to work without getting this message
can anyone help??

thanks

[davieboy]

whats the code you are using?

[mikewooten]

function db_connect($dbname='') {
global $dbhost, $dbusername, $dbuserpassword, $default_dbname;
global $MYSQL_ERRNO, $MYSQL_ERROR;

$link_id = mysql_connect($dbhost, $dbusername, $dbuserpassword);
if(!$link_id) {
$MYSQL_ERRNO = 0;
$MYSQL_ERROR = "Connection failed to the host $dbhost.";
return 0;
}
else if(empty($dbname) && !mysql_select_db($default_dbname)) {
$MYSQL_ERRNO = mysql_errno();
$MYSQL_ERROR = mysql_error();
return 0;
}
else if(!empty($dbname) && !mysql_select_db($dbname)) {
$MYSQL_ERRNO = mysql_errno();
$MYSQL_ERROR = mysql_error();
return 0;
}
else return $link_id;
}

function sql_error() {
global $MYSQL_ERRNO, $MYSQL_ERROR;

if(empty($MYSQL_ERROR)) {
$MYSQL_ERRNO = mysql_errno();
$MYSQL_ERROR = mysql_error();
}
return "$MYSQL_ERRNO: $MYSQL_ERROR";
}

[davieboy]

the code i have to connect to the db is

<?php include 'config.php'; 
    mysql_connect($db_host,$db_user,$db_pass); 
    mysql_select_db ($db_name) or die (mysql_error());

 ?>

the config file:

<?php

$db_host = "localhost";
$db_user = "username"; 
$db_pass = "password"; 
$db_name = "dbname";

?>