Hello, I have my site on one ser

[Guest_imported]

Hello,

I have my site on one server (with MySql) and for mailing I use another server which connects to MySql and sends emails and other stuff. Now, I wanted to drop my current mail server and use another one instead.

I get an access denied message from MySql whenever I try to excute a PHP script on the new server which says that access cannot be granted to the user "user@mysite.com" where it acknowledges that I have provided the password.

What could the problem be? Do I have to setup permissions or modify them? and if so, "HOW" can I go about doing this????

Please let me know if you could tell me what I have to do exactly to access MySql from a different server without getting the "Acess denied" message?!

P.S. I even tried changing the "host" from the mysql.user table by giving it the New IP but nothing happened and I still get the access denied msg.

Thanks in advance

 

[sleipnir214]

MySQL users are allowed access to resourses based on userid (with a matching password) and location from which the user connects.

Your user was allowed to connect from the IP addrss of the old server. It likely does not have permission to connect from the new one.

You need to modify the column "host" in the table "user" to reflect the new IP address.

If that does not work, take a look at the syntax for the GRANT statment:

http://www.mysql.com/doc/en/GRANT.html

______________________________________________________________________
TANSTAAFL!