Running MySQL Workbench 8.0.18 on Windows 10
Using confirmed SSH credentials that are successful with SSH/SFTP Terminal Connectivity.
However, when using the same SSH credentials in WorkBench receiving the following error:
“Could not connect the SSH Tunnel”
Access denied for ‘none’. Authentication that can continue: publickey.
1. Why is Workbench erroring out as 'none'? I did a quick search on Google and found this:
https://www.pythonanywhere.com/forums/topic/14340/
I have made sure the WorkBench Server Connection Settings are as follows:
Connection:
SSH Hostname: IP of Hosted Server
SSH Username: SSH sudo user
SSH Password: Clear
SSH Key File: Path to local Private Key
MYSQL Server: Hostname: 127.0.0.1
MYSQL Server Port: 3306
MYSQL User: confirmed MySQL database user
MYSQL User: Clear
Remote Management > SSH Login based management
Hostname: IP of Hosted Server
Username: sudo user on Hosted Server
Password: Authenticate Using SSH Key
SSH Key Path: Pathed to Private SSH Key
System Profile:
System Type: Linux
Installation Type: Ubunto Linux (MySQL Package) - Matches my Hosted Server
Configuration File: /etc/mysql/my.cnf
Configuration File Section: mysqld