Page Title

Body
If you are trying to connect to your database from a physically separate application server, see CommunicationsWithinTheCluster To access your mysql database remotely- i.e. from anything but a shell on your server- you'll need to tunnel traffic via ssh. In Linux or Mac OS X this is accomplished easily: <pre><code>ssh -f -N -L 8888:127.0.0.1:3306 deploy@your-account.railsmachina.com</code></pre> This will setup a tunnel from port 8888 on your local machine to port 3306 (the default mysql port) on your server. You can then connect to mysql using 'localhost' as the host and '8888' as the port. Using the command line client: <pre><code>mysql --user database_user --password --port 8888 --protocol=TCP database_name</code></pre> On Windows, you can create tunnels using putty or with ssh in cygwin.

Make page private