SSH Tunneling failure when connecting to MySQL
Hi,
I installed the MySQL Workbench on my macOS Sierra, and trying to connect to the MySQL RDS instance(private subnet) by an public EC2 through SSH tunneling(which named as "Standard TCP/IP over SSH" in workbench tool), but I can't establish the connection, error message as below:
16:41:38 [INF][ SSH tunnel]: Starting tunnel
16:41:38 [INF][ SSH tunnel]: Existing SSH tunnel not found, opening new one
16:41:38 [INF][ SSH tunnel]: Opening SSH tunnel to 54.254.222.199:22
16:41:38 [ERR][sshtunnel.py:notify_exception_error:235]: Traceback (most recent call last):
File "/Applications/MySQLWorkbench.app/Contents/Resources/sshtunnel.py", line 291, in _connect_ssh
self._client.load_host_keys(os.path.expanduser(ssh_known_hosts_file))
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/client.py", line 124, in load_host_keys
self._host_keys.load(filename)
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/hostkeys.py", line 101, in load
e = HostKeyEntry.from_line(line, lineno)
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/hostkeys.py", line 331, in from_line
key = RSAKey(data=decodebytes(key))
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/rsakey.py", line 64, in __init__
if msg.get_text() != 'ssh-rsa':
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/message.py", line 186, in get_text
return u(self.get_bytes(self.get_int()))
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/py3compat.py", line 53, in u
return s.decode(encoding)
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/encodings/utf_8.py", line 16, in decode
return codecs.utf_8_decode(input, errors, True)
UnicodeDecodeError: 'utf8' codec can't decode byte 0x82 in position 4: invalid start byte
16:41:39 [INF][ SSH tunnel]: TunnelManager.wait_connection authentication error: Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details
16:41:39 [ERR][ SSH tunnel]: Authentication error opening SSH tunnel: Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details
In the mean time, I tried the same connection info on another Mac computer, that is fine, so would like to know what's wrong with my current Mac?