Welcome to WebmasterWorld Guest from 107.20.122.81

Forum Moderators: open

Message Too Old, No Replies

Remote connection to mySQL

How to convert

     

universetoday

11:19 pm on May 29, 2006 (gmt 0)

10+ Year Member



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

11:43 pm on May 29, 2006 (gmt 0)

5+ Year Member



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

3:06 am on May 30, 2006 (gmt 0)

10+ Year Member



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

7:02 pm on May 30, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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

Featured Threads

Hot Threads This Week

Hot Threads This Month