SSH Tunnel Problems
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
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 :/
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.
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.