Jump to content

Archived

This topic is now archived and is closed to further replies.

Simone

Access Denied on Remote Server but not Local Server

Recommended Posts

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!

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

 

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.