Jump to content


Photo

Access Denied on Remote Server but not Local Server


  • Please log in to reply
2 replies to this topic

#1 Simone

Simone
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 04 January 2006 - 04:23 PM

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!

#2 moberemk

moberemk
  • Members
  • PipPipPip
  • Advanced Member
  • 695 posts

Posted 04 January 2006 - 09:53 PM

Most servers don't allow access to databases from the outside of their servers. This is just another case of that.
Disclaimer: No matter how harsh I may be, I'm always IMO only.

#3 degsy

degsy
  • Members
  • PipPip
  • Member
  • 20 posts

Posted 05 January 2006 - 01:52 PM

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





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users