I have tried to connect to the mysql database that is on my server through a php script connection and dreamweaver, but I continuous get this error.

Mysql Error#: 1045

Access denied for user ‘admin’@localhost (using password: YES)

However, I can connect to the mysql database through shell and phpmyadmin that plesk provides.  I know that I am using the correct username and password because I created them.  I have actually created several different usernames and passwords and they all have failed to connect through the php scripts. 

In addition, when I create a user with shell this user does not show up in the plesk interface under users of a particular database.

Furthermore, when I first attempted to use the phpmyadmin through plesk it asked me to update my priviledges table with this command:  “mysql_fix_privilege_tables”.  Which I did.


Here is the script I am using

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname = "localhost";
$database = "cn";
$username = "admin";
$password = "mypassword";
$connection = mysql_connect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);
?>

Simply put, can someone offer any advice on how I can connect to the mysql database on my server?