Remote connection to mySQL

How to convert

[universetoday]

I've got a program that's designed to connect Wordpress and VBulletin, but it's supposed to connect only from the same machine. I want to connect to the database from a remote computer.

I've tried changing "localhost" to the IP of the computer where the database is stored, but that doesn't seem to work.

Also, is there some configuration I need to do with mySQL to allow remote connections like this? I'm sure it's a security risk.

[the 1 an only]

When installing (or configuring an instance) of mySQL there's an option of allowing remote connections and to set the port. Default port is 3306, assuming you are running a firewall then this will need to be open.

Unless this is on a local and trusted network then I can't say I would suggest this method though.

[universetoday]

The computers are right next to each other, but they aren't protected by a firewall. I'm assuming there would be a way to restrict which IPs can connect to the port.

[volatilegx]

See [dev.mysql.com...] for host-related connection issues.