MySQL Forums
Forum List  »  MySQL Workbench

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).

Options: ReplyQuote


Subject
Views
Written By
Posted
277
October 11, 2023 06:31AM
Re: Workbench from MacOS to Windows server
268
October 12, 2023 12:18PM


Sorry, only registered users may post in this forum.

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.