l2t

How to resolve SSH Authentication Issue for MySQL Workbench on Mac

Asked: 22 days ago

If you are trying to connect your remote database using SSH and getting SSH Authentication Issue error. You need to convert your private ssh key to OPEN SSH format as below:

# install putty
brew install putty

# convert exiting private key to pem key
puttygen id_rsa -O private-openssh -o id_rsa.pem

Now use new key location: /Users/local/.ssh/id_rsa.pem in your MySQL Workbench connection.

SSH Hostname: <your-server-ip>
SSH Username: <your-server-user>
SSH Key File: /Users/local/.ssh/id_rsa.pem

MySQL Hostname: 127.0.0.1
MySQL Server Port: 3306
MySQL Username: <mysql-user>
MySQL Password: <mysql-pass>
Viewed: 57 times
Liked: 1 times