php - mysql error Fatal error: Access denied for user 'root'@'localhost'

[fasilmumtaz54]

Hi i have set up a php website via dreamweaver with a testing host as local
Everything works fine local i can test it all the tables of the database appear correctly on my testing server

Once i upload this i keep getting this error

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'DANI'@'localhost' (using password: YES) in /home/u466564495/public_html/Connections/MANI.php on line 9

Fatal error: Access denied for user 'DANI'@'localhost' (using password: YES) in /home/u466564495/public_html/Connections/MANI.php on line 9

I have try many things crated different user check password user names
I try other host, different servers wamp xampp easy php

but i still get the same error i dont have a clue why
This is my code

<?php
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "localhost";
$database_localhost = "cdcol";
$username_localhost = "root";
$password_localhost = "password";
$localhost = mysql_pconnect($hostname_localhost, $username_root, $password_password) or trigger_error(mysql_error(),E_USER_ERROR);
?>

i thin used easy php as a testing server and change this to
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_YYY = "127.0.0.1";
$database_YYY = "information_schema";
$username_YYY = "FAM0422";
$password_YYY = "your_password";
$YYY = mysql_pconnect($hostname_127.0.0.1, $username_FAM0422, $password_your_password) or trigger_error(mysql_error(),E_USER_ERROR);
?>


i am using windows 7 with dreamweaver8 it works fine local just not on remote host.
i greatly appreciate any ideas and help as i been stuck on this for 4 days lol
Please Help

 

[descalzo]

Did you create the database on your x10 account using cPanel --> MySQL Databases?
Create the user?
Attach the user to the database with all privileges?

The database name should be YYYYY_aaaaa where YYYYY is your cPanel username and aaaaa is the additional name you gave it.
Same with the user.

 

[misson]

In addition to descalzo's comments:

If the remote host you refer to is an X10 server, see also the X10 wiki article on MySQL connection errors.

That's obviously not the code, as the error message refers to the user "DANI@localhost", whereas the username in the code sample is "root", which makes me wonder what other differences there are.

The mysql extension is outdated and has ben supplanted twice over. Switch to PDO.

Please use

, [html] or [code] tags (as appropriate) to separate and format code.