guest OS ---> Ubuntu 22.04.1 LTS
host OS ----> MacOS 12.5.1
VMware Fusion: Player Version 12.2.4 (20071091)
mysql: Ver 8.0.30-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))
mysql Workbench 8.0.30
I'm trying to configure mysql Workbench to connect to a mysql server hosted in a virtual machine. I own and control both host and guest OSs and the mysql server.
I can connect to the Ubuntu machine via VMware's Connect to SSH option. This uses server 172.yy.yy.yy and port 22. I also provided the u/name and p/wd for the Ubuntu OS. That all work fine and I can sudo into mysql using that. I can also log in using another user that has host 'localhost'.
I cannot for the life of me figure out what I should enter into mysql workbench in order to connect though. I have created a remote access user that has as host the ip address of the MacOS (I got this just by googling 'my ip').
I have also edited /etc/ssh/sshd_config to include: ListenAddress xx.xx.xx.xx
(where xx.xx.xx.xx is my host OS's IP address).
Connection Method: I've selected Standard TCP/IP over SSH
SSH Hostname: my_guest_OS's_IP_address
SSH Username: my_guest_OS's_username
SSH Password: my_guest_OS's_username's_pwd
MySQL Hostname: 0.0.0.0
MySQL Server Port: 22
Username: my_remote_mysql_login_name
Password: my_remote_mysql_login_pwd
Default Schema: <leave_blank>
I am currently getting the below error message:
Failed to Connect to MySQL at 0.0.0.0:22 through SSH tunnel at <my_guest_OS's_username>@<my_guest_OS's_IP_address> with user <my_remote_mysql_login_name>
Cannot open SSH Tunnel: Connection refused