Re: Workbench from MacOS to Windows server
Posted by:
Sasa Galic
Date: October 12, 2023 12:18PM
Hi Tom, in case if you have MySQL database running on Windows 11 VM, and MySQL Workbench installed on MacOS (host machine) you should be able to connect using Windows 11 VM ip address (not 127.0.0.1). You can find ip address running ipconfig.exe in terminal on Win machine (IPv4 Address).
You might get an error that host is not allowed to connect. In this case you can try following (terminal on Win machine)
#Connect to sql as root
cd 'C:\Program Files\MySQL\MySQL Server 8.1\bin'
.\mysql.exe -uroot -p
#Grant access
CREATE USER 'root'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
In case if MySQL Workbench is also running on VM machine (MacOS 13) you need to port forward port 3306 on your host machine to Win machine. In this case ip address should be network router address from VM machine (MacOS 13).
For port forward you can try with ssh tunneling, but it this case you should also have SSH server running on Windows machine. I have similar setup, only instead of Windows, database is running on Ubuntu VM (as docker container).
Subject
Views
Written By
Posted
467
October 11, 2023 06:31AM
253
October 11, 2023 02:06PM
317
October 11, 2023 08:11PM
Re: Workbench from MacOS to Windows server
470
October 12, 2023 12:18PM
247
October 13, 2023 09:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.