Connect to MySQL Database via SSH (SQL Maestro)

[[chris]]

I use SQL Maestro to connect to a MySQL Database (shared server).

Remote connection works like a charm, but when I use the SSH option, I get a timeout.
SSH access via putty works, SSH is enabled by JAG Support.

for SSH access I use
- port 22,
- my domain as SSH host name
- my main accounts username and PW for SSH - Login

and additional for MySQL DB access:
- port 3306
- DB Access is enabeled for my static IP
- a valid MySQL DB user an PW
- a valid DB namw

Is SSH access to a MySQL Database possible?

Chris

[Gwaihir]

You're tunneling, like this page describes?

For hostname, you could try 127.0.0.1 instead of localhost. Localhost doesn't always work (something to do with how the servers are configured around here).

However, your problem probably is that JagPC doesn't allow any kind of tunneling; too much of a security / traffic control headache, I suppose. Masood posted some words to that effect out here a few months ago. Please do post back here if you get them to change their minds about that .

BTW: You don't need DB access from your own (home / office) IP enabled for a tunnel, for the MySQL server it will look like you arrive from localhost.

[Ron]

If you mean a MySQL client when you say "Is SSH access to a MySQL Database possible?" then Wim is correct. When connecting try

mysql -h 127.0.0.1 -u username -p

[Gwaihir]

That's definately SSH access to the MySQL databases . However, I don't think he'll be happy with that CLI interface .

[Vin DSL]

However, your problem probably is that JagPC doesn't allow any kind of tunneling; too much of a security / traffic control headache, I suppose. Masood posted some words to that effect out here a few months ago...

Well, you're richtige hälfte...

SSH Port Fowarding for WebMail Tunnel

[Vin DSL]

I digress...

I was just looking at this page: http://www.jaguarpc.com/support/kbase/702.html

The hosting services we provide, the best upgrade path depends on Control or Power.

For Control, the upgrade path is:

Shared : Reseller : VPS : Dedicated

For Power, the upgrade path is:

Shared : VPS : SDX : Dedicated

Wouldn't this make more sense?

The hosting services we provide, the best upgrade path depends on Control or Power.

For Control, the upgrade path is:

Shared -> Reseller -> VPS -> Dedicated

For Power, the upgrade path is:

Shared -> VPS -> SDX -> Dedicated

Anyway...

ON TOPIC

SSH tunneling would be available to both SDX and Dedicated...

[[chris]]

You're tunneling, like this page describes?

Exactly!

However, your problem probably is that JagPC doesn't allow any kind of tunneling; too much of a security / traffic control headache, I suppose. Masood posted some words to that effect out here a few months ago.

I see. No wonder, that it didn't work.

thx to you all

Chris