Welcome to WebmasterWorld Guest from 54.162.164.86

Forum Moderators: open

Message Too Old, No Replies

Remote connection to mySQL

How to convert

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

Full Member

10+ Year Member

joined:May 21, 2003
posts:333
votes: 0


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.

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

New User

10+ Year Member

joined:May 28, 2006
posts:3
votes: 0


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.

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

Full Member

10+ Year Member

joined:May 21, 2003
posts:333
votes: 0


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.
7:02 pm on May 30, 2006 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 22, 2001
posts:2450
votes: 0


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