How to log into db from external tool?

For PostgreSQL databases, remote access is enabled by default.

For MySQL databases, simply open a ticket and ask that we enable remote access to one or more of your databases (be sure to include the list of databases you'd like remote access enabled for).

Hope that helps!

If you're using either MySQL or PostgreSQL, you can connect to the database server remotely by following these instructions from the WebFaction User Guide:

You can access a database remotely by using an SSH tunnel, which establishes a secure connection through which ordinary database traffic can travel. It allows you to work with your database as if it were running on your local computer.

Starting an SSH Tunnel with ssh

• Open a terminal session.

• Enter ssh -L 3306:127.0.0.1:3306 username@webXX.webfaction.com where webXX is your machine name (e.g. web57) and press Enter.

Note: For PostgreSQL, substitute 3306 with 5432: ssh -L 5432:127.0.0.1:5432 username@webXX.webfaction.com

• You may be alerted that the authenticity of the host cannot be established. Enter yes and press Enter.

• When prompted, enter your password and press Enter.

• Leave the SSH session open as long as you want to maintain the tunnel.

• You can now connect to your database at 127.0.0.1, port 3306 using your database name (as username) and password.

• Enter exit and press Enter to close the connection.