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? 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 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. 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). 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 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
Archived
This topic is now archived and is closed to further replies.