Jump to content

Archived

This topic is now archived and is closed to further replies.

black.horizons

access mysql db from another server

Recommended Posts

Hi there,

I have MySQL database sitting on one server, and I have a website residing on another server, the one with the database is a personal server, and the website is a club site I'm running. The club can't afford £180 a year for MySQL access but my own server already has it running for £30 a year...so I want to know how (if its possible) to connect from server A to server B. the PHP file for the club resides on the club server, and the db it's meant to access resides on another server.

Thanks in advance,

Alex

Share this post


Link to post
Share on other sites
All you have to do is specify an IP address instead of localhost in the connection string. Of course, you'll need to make sure that your server is set up to allow external connections.

Share this post


Link to post
Share on other sites
Also, it sounds like a good opportunity to learn how to get your MySQL server to use SSL! (Not that I can tell you how, but it's something on my plate to learn as well... After I get my 6-table many-many-many thingy figured out I'll be moving on to the MySQL security issues.

Maybe I'll post a tutorial on my website for both issues when the time comes, because I'm not having much luck finding a resource that I can wrap my head around for the many-many-many issue, and thre can never be too many security tutorials :)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.