black.horizons Posted March 3, 2006 Share Posted March 3, 2006 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 Quote Link to comment https://forums.phpfreaks.com/topic/4014-access-mysql-db-from-another-server/ Share on other sites More sharing options...
fenway Posted March 3, 2006 Share Posted March 3, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/4014-access-mysql-db-from-another-server/#findComment-13973 Share on other sites More sharing options...
SpectralDesign.Net Posted March 4, 2006 Share Posted March 4, 2006 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 :) Quote Link to comment https://forums.phpfreaks.com/topic/4014-access-mysql-db-from-another-server/#findComment-14097 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.