MySQL (Workbench) Connection Issue

[Hans Vledder]

All,

I have the following situation which I do not seem to be able to resolve, I would appreciate your help:

Setup

1. MySQL 8.4.2 (CE) database server running on Debian 12 (No [ufw] firewall installed), hostname euphrosyne.josaire.net, IP address 192.168.1.54, port 3306 (IPv4) hosted on XCP-ng 8.2.

2. System Administrator Workstation on Windows 10, running MySQL Workbench v8.0.38, hostname hades.josaire.net, IP address 192.168.1.68, hosted on VMWare Workstation 17 Pro.

[Don't worry, all of this lives on the trusted side of the firewall]

Issue

* Whatever I do, I am not able to connect to the MySQL database server from my system admin workstation.

Things tried:

1. Created user 'root'@'hades.josaire.net' with a known password and all privileges.
2. Created user 'root'@'192.168.1.168' with a known password and all privileges.
3. Pinging euphrosyne.josaire.net from hades.josaire.net -> no problem.
4. Ran a port scan from hades.josaire.net against euphrosyne.josaire.net -> ports found 22, 3306
5. Connecting over SSH from hades.josaire.net to euphrosyne.josaire.net works as expected.
6. Reinstalled MySQL server on a new 'machine', replacing the old 'machine'.
7. There are no other connectivity issues to external services from hades.josaire.net

Long story short: Help!!
-- Hans