MySQL access denied from different Server

[NoLogic]

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@NewIPAddress" where it acknowledges that I have provided the password.

I even changed the column "host" from the mysql.user and mysql.db table by giving it the New IP but nothing happened and I still get the access denied msg. Database is still accessible by the same user from the old mail server.

What could the problem be? Where the authentication of the server is processed?

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?

Thanks in advance

 

[piti]

hi

if you modified the grant tables manually, with INSERT or UPDATE, execute "FLUSH PRIVILEGES" or run mysqladmin flush-privileges
this reloads the grant tables
if you do not do that, your changes will have no effect until the next restart of the mysql server

hope that helps