Possible to connect to remote database?
Posted by: pthesis (---.secure-wi.com)
Date: February 02, 2010 09:59PM

I've been running WAMP for a while and it works great. Now I want to try something different, and I don't know if it's possible.

I want to connect a PHP application hosted locally through WAMP to a remote database. I've enabled remote access to the database through the hosting provider, and set up a SSH tunnel.

My WAMP installation is running on localhost:81, so my question is how would I access the remote database once I'm in the SSH session? Would it be localhost, localhost:3306, or something else? Specifically, I'm trying to install Joomla, so what would I specify as the remote database's address in the Joomla setup screen?

And is this even possible? localhost:81 refers to the local WAMP server, so is it possible for localhost or localhost:3306 or something else to refer to the server connected to through SSH?


Thanks for your help,
pthesis.

Options: ReplyQuote
Re: Possible to connect to remote database?
Posted by: stevenmartin99 (---.b-ras2.blp.dublin.eircom.net)
Date: February 02, 2010 10:19PM

u need the external ip of the server ur connecting to or the url such as

mysql.myhost.com

u shud know it , if u set it up

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote


Sorry, only registered users may post in this forum.