homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Remote connection to mySQL
How to convert

 11:19 pm on May 29, 2006 (gmt 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.


the 1 an only

 11:43 pm on May 29, 2006 (gmt 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)

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)

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

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved