tmallen Posted December 11, 2008 Share Posted December 11, 2008 I'm working on a multi-server setup, and I have a big problem: How do I make my application server talk to a separate database server? I know that I can't just point mysql_connect to the other IP address. Does anyone know of good resources about configuring each server to talk to the other? Quote Link to comment https://forums.phpfreaks.com/topic/136562-solved-linking-php-to-a-separate-db-server/ Share on other sites More sharing options...
rhodesa Posted December 11, 2008 Share Posted December 11, 2008 um, you should just be able to use the remote server's IP address. and, for the user/pass you are using to connect, make sure external connections are allowed in the mysql privileges Quote Link to comment https://forums.phpfreaks.com/topic/136562-solved-linking-php-to-a-separate-db-server/#findComment-712850 Share on other sites More sharing options...
tmallen Posted December 11, 2008 Author Share Posted December 11, 2008 Thanks! I had the first parts (grant privileges from the remote IP, point mysql_connect vice versa) but I didn't know about external connection allowance. Quote Link to comment https://forums.phpfreaks.com/topic/136562-solved-linking-php-to-a-separate-db-server/#findComment-712865 Share on other sites More sharing options...
tmallen Posted December 11, 2008 Author Share Posted December 11, 2008 In the end, I just had to open 3306 to the other IP (no MySQL setting was required). Quote Link to comment https://forums.phpfreaks.com/topic/136562-solved-linking-php-to-a-separate-db-server/#findComment-712888 Share on other sites More sharing options...
rhodesa Posted December 11, 2008 Share Posted December 11, 2008 ah...firewalls/routers...should have mentioned that Quote Link to comment https://forums.phpfreaks.com/topic/136562-solved-linking-php-to-a-separate-db-server/#findComment-712896 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.