how to connect to mysql from outside computer

[juschillinnow]

I have a mysql database running on "computerx" and I connect to it via use of "localhost" when I run scripts from "computerx".

I also have a "computery" that I have php scripts on. I need to connect to the mysql database running on "computerx" so I can use the same information.

How do I do this???

Thanks

[juschillinnow]

does anybody know how to do this?

[Bunkermaster]

yeah open the port on your firewall and give computerx IP to mysql_connect
read carefully:
http://www.php.net/manual/en/function.mysql-connect.php

[rinjani]

First make sure that computerx can see computery on your network.

Set up your connect script as normal but use computery.mydomain.com (or whatever the full network name of your computer is) instead of localhost.

In the mysql database users setup your user id for the access from computery with a listing for userx@localhost AND for userx@% or userx@computery.

HTH