These are the steps I performed to set up mySQL server on my own desktop.
- Installed Cygwin
- Installed openssh. Then
ssh-host-config
... - Then I created a new connection established via "Standard TCP/IP over ssh".
- Tested the connection. And it worked fine.
- Open Connection and grant access to
MacUser
...
Now I move to my Mac Laptop. And I want to be able to connect remotely using my MacOS laptop to the mySQL server resided in my desktop.
So i typed in the SSH Hostname
and SSH Username
and the password as well as the id_rsa.pub
file. Then i tested the connection and got the following error messages.
Could not connect the SSH Tunnel.
Authentication error. Please check that your username and password are correct and try again.
Details (Original exception message):
Authentication failed, please check credentials.
Please refer to logs for details
Question : I am confident that my SSH Hostname and SSH Username and password are correct. My only concern is how would the mySQL server on my desktop recognize and approve the SSH key id_rsa.pub
on my Mac ? Am I suppose to impose some rules in the ssh config files on my desktop first?
Please forgive me if this is a naive question but this is my first time playing around with ssh.
UPDATE:
I have attached the error logs below.
15:50:12 [INF][ SSH tunnel]: Existing SSH tunnel not found, opening new one
15:50:12 [INF][ SSH tunnel]: Opening SSH tunnel to <ip>:22
15:50:12 [ERR][sshtunnel.py:notify_exception_error:234]: Traceback (most recent call last):
File "/Applications/MySQLWorkbench.app/Contents/Resources/sshtunnel.py", line 302, in _connect_ssh
look_for_keys=has_key, allow_agent=has_key)
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/client.py", line 367, in connect
look_for_keys, gss_auth, gss_kex, gss_deleg_creds, gss_host)
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/client.py", line 584, in _auth
raise saved_exception
AuthenticationException: Authentication failed.
15:50:13 [ERR][ SSH tunnel]: Authentication error opening SSH tunnel: Authentication error. Please check that your username and password are correct and try again.
Details (Original exception message):
Authentication failed, please check credentials.
Please refer to logs for details
/var/log
and have a look.