This has already been covered on the forums already: Can`t install snap - #6 by iwalker in relation to snap a thread that started for Rocky 10 which is dependent on snap packages from EPEL which is the problem. But since Rocky 9 also relies on snap packages from EPEL, then the problem is the same.
Assuming that snap isn’t the problem from EPEL, and some other dependencies for MySQL Workbench, then you will need to post more detailed information into what exactly the problem is - like what dependencies cannot be installed?
Also, according to here: https://pkgs.org/ searching for libproj which seems to be a dependency for MySQL Workbench, doesn’t exist for any EL system - not for RHEL, not for Rocky, Alma or any others.
I just downloaded mysql-workbench-community-8.0.45-1.el9.x86_64.rpm and attempted to install. So the problem is caused by the fact libproj.so.22 doesn’t exist in any existing package on Rocky. So either they have built against a package called proj that will appear in Rocky 9.7, in which case you need to wait until Rocky 9.7 is released. That may potentially solve the problem, although the proj package provides libproj.so.25.