SSH Tunnel Problems

[expired user #8317]'s profile image [expired user #8317] posted 10 years ago in Creating a connection Permalink
Greetings.

First of all sorry for my english...I m just a german guy.

Nevertheless I got some probs with Heidi. Either I m just to stupid or something is really missing...probably both. Here s whats going wrong:

Setting:
MySQL TCP/IP
Hostname 127.0.0.1
User root
no pass
Port 3306
=> works like a charme. I can connect to my own database without probs.

Now I want to connect to a DB on a webpage that normally uses phpmyadmin...let's say "www.mytestpage.de/phpmyadmin".
I can login there with the Root-account and his passwort, no prob.
So I tried to use that in Heidi and changed from "MySQL TCP/IP" to "MySQL SSH tunnel)

Settings-tab: no change here
SSH-tunnel-tab:
plink.exe location is set, no prob
SSH host + port "mytestpage.de" | 3306
Username Root
Passwort *****
plink.exe timout 20
Private Key file is set although I don't know if needed...I get the same error message
Local Port 3307

Error message is always:
SQL Error 2003 in statement #0: Cant connect to MySQL server on localhost (10061)

Advanced-tab is empty...just in case.

If you guys got any ideas feel free to tell me. First correct solution wins a free beer. :)

Thx!
TZP
[expired user #8317]'s profile image [expired user #8317] posted 10 years ago Permalink
Additional note: I use Xampp if that helps.
[expired user #8317]'s profile image [expired user #8317] posted 10 years ago Permalink
Ok, here we go...turns out that my private key file was not on the server. I changed that and now I can access via putty.
Config on Putty looks like this:

Host Name mytestpage.de Port 22
SSH->Auth->Private key file = Location of my private key
Login root
Pass is the passwort of my private key file and after that putty lets me in...screen says

root@mytestserver:~$

Still the same error on Heidi though :/
jfalch's profile image jfalch posted 10 years ago Permalink
SSH port should be 22.
[expired user #8317]'s profile image [expired user #8317] posted 10 years ago Permalink
Shazaam! I got it. Port is 22, I second that. However I had to made some adjustments. Maybe this helps other ppl one day.

Settings:
Hostname 127.0.0.1
User root (or whatever your masteruser is called)
Password hispassword (again the masteruser on your page, not from localhost)
Port 3306

SSH-tunnel
Plinkfile no change here, just your file
SSH Host + Port mytestpage.de | 22
Password thePasswordFromMyPrivateKey
timeout 30 (just to be sure)
private key file...take a wild guess
Local port 3307

And because of reasons: the superuser on mytestpage.de is not root, I renamed it for security reasons.
[expired user #8317]'s profile image [expired user #8317] posted 10 years ago Permalink

Shazaam! I got it. Port is 22, I second that. However I had to made some adjustments. Maybe this helps other ppl one day.

Settings:
Hostname 127.0.0.1
User root (or whatever your masteruser on your testpage.de is called)
Password hispassword (again the masteruser on your testpage.de, not from localhost)
Port 3306

SSH-tunnel
Plinkfile no change here, just your file
SSH Host + Port mytestpage.de | 22
Password thePasswordFromMyPrivateKey
timeout 30 (just to be sure)
private key file...take a wild guess
Local port 3307

And because of reasons: the superuser on mytestpage.de is not root, I renamed it for security reasons.

Please login to leave a reply, or register at first.