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>