MySQL Workbench installation issues on Fedora 42: Dependency problems and alternatives

Hey everyone,

I’m trying to get MySQL Workbench up and running on my Fedora 42 system for a class project. I know it’s not the newest tool out there, but I need it for my studies.

I’ve got DataGrip too, but I can’t figure out how to make local databases and diagrams with it. The diagram part is super important for my work.

Here’s the problem I’m facing:

MySQL Workbench installs fine, but it crashes right away when I try to open it. It’s complaining about libssh.so.4. I tried to install this, but apparently I already have a newer version that doesn’t play nice with MySQL Workbench.

When I run it, I get this error:

/usr/libexec/mysql-workbench/mysql-workbench-bin: /usr/lib64/mysql-workbench/libssh.so.4: version `LIBSSH_4_10_0' not found (required by /lib64/libcurl.so.4)

I tried installing an older version of libssh, but no luck there either.

Can anyone help me out? Either with fixing this MySQL Workbench issue or showing me how to make databases and diagrams in DataGrip? Thanks a bunch!

As someone who’s been in your shoes, I totally get the frustration with MySQL Workbench on Fedora. Have you considered giving DBeaver a shot? It’s been my go-to for a while now, especially when I hit roadblocks with other tools.

DBeaver is pretty versatile and works well on Fedora. It handles local databases like a champ and has a solid ERD (Entity Relationship Diagram) feature that might tick your boxes for diagramming. Plus, it’s open-source and actively maintained, which is always a bonus.

To install it, you can use:

sudo dnf install dbeaver

It’s got a bit of a learning curve, but once you get the hang of it, it’s really powerful. Might be worth exploring as an alternative to MySQL Workbench, especially if you’re hitting dependency issues. Just my two cents from dealing with similar headaches!

I’ve encountered similar issues with MySQL Workbench on Fedora before. One workaround that worked for me was using Flatpak to install MySQL Workbench. It handles dependencies differently and might bypass the libssh problem you’re facing.

To try this, you can run:

flatpak install flathub com.mysql.workbench

This should install a sandboxed version of MySQL Workbench that doesn’t conflict with your system libraries.

As for DataGrip, while it’s primarily for querying, you can actually create local databases. Connect to your MySQL server, right-click on it in the database tree, and select ‘New’ > ‘Database’. For diagrams, try the ‘Database Diagram’ feature under the ‘Tools’ menu. It’s not as comprehensive as MySQL Workbench’s diagram tool, but it might suffice for your needs.

yo, have u tried using docker? it’s pretty sweet for avoiding dependency hell. just pull the mysql workbench image and run it in a container. no more worrying about libssh versions or anything. plus, it’s portable af. might be worth a shot if ur still stuck!