Problem connecting to mysql server with Navicat

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?

[wheel]

You've probably fixed this by now, but I would expect it's 90% likely that it's not the key. More likely a problem with permissions on your tables.
I suggest you fire up a copy of webmin and use it to check your mysql user and table permissions. I've seen your error in the past and that's how I corrected my problem.