homepage Welcome to WebmasterWorld Guest from 54.161.200.144
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Remote connection to mySQL
How to convert
universetoday




msg:1578904
 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




msg:1578905
 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.

universetoday




msg:1578906
 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.

volatilegx




msg:1578907
 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