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
MySQL Server Port:
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