Problem connecting via ssh to mysql Heidi

I am trying to connect to MySQL on my server via ssh using plink.exe

SSH host + port: "ip_number_of_server":"port"
Username: "Sudo_user"
Private key file: "private_key.ppk"

Mysql side:

Hostname/ip: "127.0.0.1"
User: "root"
password: "password"
port: "default_port_number"

I get this error:

Access denied for user 'root'@'localhost' (using password: yes)

In meantime I used workbench but converting private.ppk to private.pem. This worked and I was able to connect to MySQL server.

But when I use same private.pem key on Heidi, I get an error message that .pem is too old, literally. So what else can I do? I prefer Heidi over Workbench, so any help would be appreciated.



Read more here: https://stackoverflow.com/questions/66266444/problem-connecting-via-ssh-to-mysql-heidi

Content Attribution

This content was originally published by filtertips at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: