Connect to MySQL (WAMP) via SSH

Question

Hi I installed the latest WAMP on Windows 7. I would like connect via SSH to MySQL database and create dump.

As SSH client I use PUTTY.

I tried using the root account and also other accounts, but I get this error:

server unexpectedly closed network connection

Then I tried using another SSH client Private Shell http://www.privateshell.com/

I get this error:

other side does not support SSH protocol on this port

For connection I use these settings:

MySQL version is 5.5.16 I am not sure if support SSH connection.

Is it needed to allow SSH in phpAdmin or what is the root of problem?

Ashwin kumar · Answer 1 · 2011-11-09 00:11:16Z

up vote 1 down vote

Is there a SSH server on your machine?? If not you may install copssh - OpenSSH for Windows or similar and then try to connect.

answered Nov 9 '11 at 0:11

Ashwin kumar
18116

codescope · Answer 2 · 2011-12-09 04:44:49Z

up vote 1 down vote

You need to have ssh server running on windows. I use bitvise winsshd

answered Dec 9 '11 at 4:44

codescope
111

Gaius · Answer 3 · 2011-12-09 16:18:21Z

up vote 0 down vote

You need to

Configure SSL on the server
Connect using the MySQL command line tool, not PuTTY which is a terminal emulator

answered Dec 9 '11 at 16:18

Gaius
7,1671033

3 Answers