WebFaction
Community site: login faq

Do I need to register an external IP address that I'm connecting from in order to connect to the database from an external database management tool, like SQLYog?

Thanks.

asked 07 Sep '12, 23:06

Dewey
111
accept rate: 0%


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!

permanent link

answered 07 Sep '12, 23:10

ryans ♦♦
5.0k93360
accept rate: 43%

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.

permanent link

answered 08 Sep '12, 07:08

turgs
7410
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×84
×14
×3

question asked: 07 Sep '12, 23:06

question was seen: 5,922 times

last updated: 08 Sep '12, 07:08

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2019 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM