Access Denied on Remote Server but not Local Server

[Simone]

Hi I'm new to Dreamweaver, PHP and MySql.

I have setup a login page which redirects users to different sites depending on their loginname. It works perfectly on the testing server on my local hard drive but when I upload it to the remote server I get:

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'root@localhost' (Using password: YES) in ftpserver\path\connection.php on line 9

 

Fatal error: Access denied for user: 'root@localhost' (Using password: YES) in ftpserver\path\connection.php on line 9

PHP Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'root@localhost' (Using password: YES) in ftpserver\path\connection.php on line 9 PHP Fatal error: Access denied for user: 'root@localhost' (Using password: YES) in eftpserver\path\connection.php on line 9

 

Line 9, in connection.php incidentally is:

$connTownsend = mysql_pconnect($hostname_connTownsend, $username_connTownsend, $password_connTownsend) or trigger_error(mysql_error(),E_USER_ERROR);

 

The database, login name and password names are correct as I have not changed them on upload to remote server.

 

I'm using Dreamweaver 8 and My SQL Server 5.0.

 

Any help would be much appreciated as I have looked at this so long now I am going round in circles!

[moberemk]

Most servers don't allow access to databases from the outside of their servers. This is just another case of that.

[degsy]

Also most hosts will not allow a root user. You need to set up a new user in the database.