This article explains how to properly install MySQL Workbench on Debian 11 and Linux based distributions.
Currently, the official method for installing MySQL Workbench does not work as expected on Debian 11. Some users have reported that the MySQL Workbench repository was not added correctly and manually adding it does not solve the problem. Other users have complained that manual installation of Ubuntu does not work with Debian, and we can confirm this. However, installing MySQL Workbench on Debian 11 using Snap is pretty straightforward.
Before installing MySQL Workbench on Debian 11, update your repositories as shown below:
sudo apt update
Install the snapd package by running the following command:
sudo apt install snapd
Install the kernel files using Snap by running the following command:
sudo snap install core
Now, to install MySQL Workbench using Snap, run the following command:
sudo snap install mysql-workbench-community
Once installed, you can find MySQL Workbench in the Application Finder, or in the Applications Menu.
In Debian 11, you will see a warning that the operating system is not supported. MySQL Workbench currently supports the following operating systems: Ubuntu, Red Hat Enterprise, Oracle Linux, Fedora and Microsoft Windows. The fact that your system is not officially supported can be ignored, and this does not mean that you will run into errors. However, below I decided to add some Linux compatible alternatives to MySQL Workbench.
More information on MySQL Workbench can be found at https://www.mysql.com/products/workbench/.
MySQL Workbench alternatives:
As you can see, many Linux distributions, including Debian 11, are not officially supported by MySQL Workbench. This is why we decided to add a short description of some of the most popular alternatives for managing and developing MySQL (and others) databases.
Dbeaver is a free and open source database management tool. Dbeaver is multi-platform (available for Linux, Windows and Mac). This tool supports not only MySQL but also PostgreSQL, SQLite, Oracle, SQL Server, DB2, Teradata, MS Access, Sybase, Firebird, Apache Hive and others. Users can write their own plugins. DBeaver supports data sources in the cloud and can be integrated with Excel, Git, and other extensions, among other features. Dbeaver has a free Community edition and a paid Enterprise edition. This tool is widely supported by the community, which also has CloudBeaver for managing databases from a web browser.
You can download Dbeaver or read more information about it at https://dbeaver.io/.
Navicat is another MySQL Workbench alternative. Navicat is not free. The cheaper plan costs $ 15 per month. Navicat is a multi-platform available for Linux, macOS, iOS and Microsoft Windows. Navicat is used to manage and develop MySQL and MariaDB databases. When using Navicat, you can connect to multiple MySQL and MariaDB at the same time. Navicat is also cloud database compatible, intuitive and graphically powerful.
You can download Navicat 15 for MySQL or find more information at https://www.navicat.com/.
Data Grip is another tool also available for Linux for creating and modifying database objects. Data Grip supports MySQL, PostgreSQL, Oracle Database, SQL Server, HyperSQL, Apache Derby, Exasol, Azure, Amazon Redshift, and more. With Data Grip, you can add, edit, delete and clone rows of data. It was designed for easy browsing and data retrieval. Data Grip has a user-friendly interface for adding and editing tables, indexes, columns, and more. It also provides smart code completion, code control, and rapid error warning with quick fixes. Data Grip is not free, but it does offer a 30-day trial that you can use for testing.
To download the Data Grip or for more information about it, visit https://www.jetbrains.com/datagrip/.
phpMyAdmin is probably the most popular alternative. PhpMyAdmin is present in almost every hosting service and is one of the most popular tools for managing MySQL over the Internet. It is a great tool for managing databases, tables, relationships, columns, indexes, users, and more. It has an intuitive web interface that allows you to import and export data in CSV and SQL formats. With phpMyAdmin, you can manage multiple servers, graph your database, solve complex queries, perform global searches, and convert data to a different format.
For more information on phpMyAdmin you can visit https://www.phpmyadmin.net/.
As you can see, it is quite easy to install MySQL Workbench on Debian 11, even if Debian 11 is not officially supported. Users just have to install it using Snap instead of manually installing the package offered on the MySQL website. Using Snap, the process is extremely easy and any Linux tier user can achieve it with a few steps. In addition, users have many alternatives in case their system is not officially supported. All MySQL Workbench alternatives listed in this guide are Linux compatible.
Thank you for reading this article, which explains how to install MySQL Workbench on Debian 11.