MySQL ODBC Driver SSH Connection with keys
I'm probably being pretty inept here, but I'm banging my head against the wall trying to get this to work.
I'm able to setup an ODBC connection using the SSH tab (under the security tab) if I enter the server IP address, the username and the user password. We want to disable password authentication and move to keys.
In Windows 10, I used ssh-keygen to create an ssh key pair with a password. I copied the public key into the authorized_keys on my server (an Ubuntu 22.04 server). From Windows 10, I am able to use OpenSSH to connect using the key.
I updated my ODBC connection to point to the private key file and gave it the password for the private key. But when I test the connection, I just get this error:
[Devart][ODBC][MyDQL]Authentication failed publickey,password
Any thoughts on what I may be doing wrong?