The MySQL Workbench is a visual database design tool is used by database managers for development, administration, and data modeling for the MySQL database. Furthermore, it supports database design through an EER diagram which in turn generates SQL scripts. It succeeds the DBDesigner 4 from fabFORCE.net as well as replacing the previous MySQL GUI Tools Bundle package.
MySQL Workbench offers the following features:
- Wizard driven action items
- Supports custom plugins
- Schema object browsing, inspection, and search
- Database Connection & Instance Management
- Supports MySQL Enterprise features (Audit Log, Firewall, and Enterprise Backup)
- Fully scriptable with Python and Lua
- It has the MSAA (Windows Accessibility API) compliant
- SQL syntax highlighter and statement parser
- Visual EXPLAIN
- Supports SSH connection tunneling
- Reverse engineering from SQL Scripts and live database as well as forward engineering to SQL Scripts and live database
- Data modeling using ER diagramming, Drag’n’Drop visual modeling, Schema synchronization e.t.c
- Unicode support
- Performance monitoring through Performance Schema metrics, Query statistics, MySQL instance dashboard e.t.c
- Supports database migration to any ODBC compliant database
- It provides a native support to Microsoft SQL Server, PostgreSQL, SQL Anywhere, SQLite, and Sybase ASE
By the end of this guide, you should be able to install and use Mysql Workbench on Fedora. Before we begin on the installation, ensure that all the packages on Fedora are updated to their latest stable versions.
sudo dnf updateInstall MySQL MySQL 8.0 using the dedicated guide below.
Install Mysql Workbench on Fedora
There are two methods you can use to install Mysql Workbench on Fedora namely:
- Using the YUM repository.
- Using snap
Method 1: Install Mysql Workbench on Fedora using the YUM repository.
Use the below steps to install MySQL Workbench on Fedora using the YUM repository:
Step 1: Download the official MySQL Yum Repository
Before we install MySQL Workbench on Fedora we need to add the MySQL Yum repository to our system. This is achieved by visiting the official MySQL downloads page and downloading the MySQL community RPM package.
On the page, there are several packages for Fedora systems, download one that suits your system.
##For Fedora 38
wget https://dev.mysql.com/get/mysql80-community-release-fc38-2.noarch.rpm
##For Fedora 37
wget https://dev.mysql.com/get/mysql80-community-release-fc37-2.noarch.rpm
##For Fedora 36
wget https://dev.mysql.com/get/mysql80-community-release-fc36-1.noarch.rpm
##For Fedora 35
wget https://dev.mysql.com/get/mysql80-community-release-fc35-1.noarch.rpm
##For Fedora 34
wget https://dev.mysql.com/get/mysql80-community-release-fc34-2.noarch.rpm
##For Fedora 32
wget sudo dnf -y install https://dev.mysql.com/get/mysql80-community-release-fc32-1.noarch.rpm
Once the download is complete, install the package using the command:
sudo rpm -Uvh mysql80-community-release-*Sample Output:
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:mysql80-community-release-fc37-1 ################################# [100%]Step 2: Install the MySQL Workbench on Fedora
Once the repository has been installed, we will proceed and install the MySQL Workbench using the single command below:
sudo dnf install mysql-workbenchSample Output:
....
Transaction Summary
======================================================================================================================================================================================================
Install 204 Packages
Total download size: 711 M
Installed size: 1.2 G
Is this ok [y/N]: yMethod 2: Install Mysql Workbench on Fedora using Snap.
This is yet another method you can use to install MySQL workbench on your Fedora system.
But before we do the installation, ensure that snap is installed on Fedora.
sudo dnf install snapdStar and enable snap on Fedora
sudo systemctl enable --now snapd.socket
Enable classic snap support.
sudo ln -s /var/lib/snapd/snap /snapNow install the MySQL Workbench Community using snap as below;
$ sudo snap install mysql-workbench-community
mysql-workbench-community 8.0.25 from Tonin Bolzan (tonybolzan) installedUse Mysql Workbench on Fedora
After a successful installation of MySQL Workbench launch it from the terminal as below.
$ mysql-workbenchAlternatively use the App Menu as below:
MySQL Workbench will start as below:
Connect to your database instance, you can choose to connect to the local instance on your machine or another instance by clicking +. Fill in the required information.
Provide a password for the local instance connection.
On successful authentication, you will see this admin dashboard.
Check the connected database server status:
Manage users and privileges as below.
Assid from the administration, you can switch to the schemas tab.
Here, you can view available databases, create tables, import data into them e.t.c. You can also create a new schema to the connected database as below.
That is it for now!
We have just covered a few tips on how to get started with MySQL Workbench on Fedora. There are many more management activities you can do to a database with MySQL Workbench. I hope this guide was helpful.
Recommended books:
See more on this page:
