WebFaction
Community site: login faq

I have a private MysQL instance running on my webfaction account which I can connect to through the command line. I've been able to create additional users through this documentation. And I know how to get an external program (SQLyog, MySQL Workbench) connect to the non-private (traditional) MySQL instances that webfaction offers, using this documentation, after the ticket has been submitted.

But is there a way I can use those same programs, via SSH tunnel I assume, to connect to my private instance as well?

asked 29 Jun '13, 12:12

diginized
113
accept rate: 0%


I actually answered my own question while typing it, but I figured I'd post it anyway in case anyone else came to the same question. It's actually fairly simple, just change the MySQL Server Port number to the port of your private instance.

For example, if you're using MySQL Workbench, the following should work:

SSH Hostname: web###.webfaction.com:22
SSH Username: <your_webfaction_username>
SSH Password: <your_webfaction_password>
SSH Key File: -null-
MySQL Hostname: 127.0.0.1
MySQL Server Port: <your_private_instance_port> (found in the [webfaction control panel][1])
Username: <root one that you've created>
Password: <to match the line above>

And that should work.

permanent link

answered 29 Jun '13, 12:19

diginized
113
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:

×168
×12
×3
×1

question asked: 29 Jun '13, 12:12

question was seen: 2,988 times

last updated: 29 Jun '13, 12:19

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2020 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