MySQL connection to another server

[Eirik]

Hi,

For testing purposes, I want the PHP scripts at my site to connect to the mysql engine located at my local computer. I've tried inserting my computers IP address in stead of localhost in the mysql_connection function call, but that doesn't do it.

I've heard something about having to alter the mysql.db to accomplish this, but I don't know where to alter, and what to alter to.

Any insight is greatly appreciated !

[HarryF]

Your right - you will need to make updates to MySQLs permissions on the remote db. MySQL distinguishes between local users, on the same machine, and remote users.

It's all best explained in this article.

[galt]

You may also find a useful tidbit in the footnote to this article.

http://www.udzone.com/go?1221