Problem connecting to mysql db on remote server

"bad private key" error message?

[akmac]

Hi folks,

Just installed oscommerce successfully on a dedicated remote server running Plesk 7. I'm attempting to connect to the DB via Navicat so I can add my product information. I'm sure my settings are correct as they are the same ones I used to install oscommerce successfully.

The error message I get is: "SSH Tunnel: 30016 Invalid username or password reported by server, or bad private key."

As I named the db myself and created my own user with password and all permissions-the problem must lie with the "bad private key".

Now let me unfold my glorious noobness:

How do I get a private key? I have a vague theoretical understanding of it's nature and purpose (unencrypting data in conjunction with my public key) but no pactical knowledge or experience. Do I need an SSL certificate or something configured before I can connect via SSH? (I'm using SSH because I'm behind a firewall- and heard it's more secure?)

I'm also trying to connect from my Mac using cocoamysql but that has no ssh option that I'm aware of... So no joy there either.

Any help?

[BjarneDM]

As far as I can see you are tunnelling you database connection through a SSH connection. This means you'll have to set up SSH to intercept the connection and connect to the SSH service on your own computer (localhost) instead of the foreign DB-server.

read here:
[devshed.com...]
[hackinglinuxexposed.com...]
[hackinglinuxexposed.com...]

[freeflight2]

mysql supports SSL. Did you check your server's logfiles? most implementations try a private key, then revert to password authentication. Starting the server in "verbose" mode also might enlighten you.

[BjarneDM]

@freeflight2:
SSH and SSL have nothing at all to do with each other.

The problem as posed by akmac clearly involves SSH tunneling according to the error message. SSL usually has to be explicitly compiled into MySQL. SSH tunneling has nothing at all to do with whether or not SSL is supported by MySQL