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 36/35/34/33/32. 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.
#1) Install Mysql Workbench on Fedora 36/35/34/33/32
There are two methods you can use to install Mysql Workbench on Fedora 36/35/34/33/32 namely:
- Using the YUM repository.
- Using snap
Method 1: Install Mysql Workbench on Fedora 36/35/34/33/32 using the YUM repository.
Use the below steps to install MySQL Workbench on Fedora 36/35/34/33/32 using the YUM repository:
Step 1: Download the official MySQL Yum Repository
Before we install MySQL Workbench on Fedora 36/35/34/33/32 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 32
wget sudo dnf -y install https://dev.mysql.com/get/mysql80-community-release-fc32-1.noarch.rpm
##For Fedora 33
wget https://dev.mysql.com/get/mysql80-community-release-fc33-2.noarch.rpm
##For Fedora 34
wget https://dev.mysql.com/get/mysql80-community-release-fc34-2.noarch.rpm
##For Fedora 35
wget https://dev.mysql.com/get/mysql80-community-release-fc35-1.noarch.rpmOnce the download is complete, install the package using the command:
sudo rpm -Uvh mysql80-community-release-*Sample Output:
warning: mysql80-community-release-fc34-2.noarch.rpm: Header V3 DSA/SHA256 Signature, key ID 5072e1f5: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:mysql80-community-release-fc34-2 ################################# [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 yum install mysql-workbenchSample Output:
Dependencies resolved.
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
mysql-workbench-community x86_64 8.0.27-1.fc34 mysql-tools-community 37 M
Installing dependencies:
pcre-cpp x86_64 8.44-3.fc34.1 fedora 26 k
proj x86_64 7.2.1-2.fc34 fedora 2.6 M
Installing weak dependencies:
proj-data-at noarch 7.2.1-2.fc34 fedora 2.1 M
proj-data-au noarch 7.2.1-2.fc34 fedora 117 M
proj-data-be noarch 7.2.1-2.fc34 fedora 726 k
proj-data-br noarch 7.2.1-2.fc34 fedora 1.0 M
proj-data-ca noarch 7.2.1-2.fc34 fedora 93 M
proj-data-ch noarch 7.2.1-2.fc34 fedora 1.5 M
proj-data-de noarch 7.2.1-2.fc34 fedora 72 M
proj-data-dk noarch 7.2.1-2.fc34 fedora 9.7 M
proj-data-es noarch 7.2.1-2.fc34 fedora 1.0 M
proj-data-eur noarch 7.2.1-2.fc34 fedora 1.0 M
proj-data-fi noarch 7.2.1-2.fc34 fedora 90 k
proj-data-fo noarch 7.2.1-2.fc34 fedora 9.2 k
proj-data-fr noarch 7.2.1-2.fc34 fedora 1.2 M
proj-data-is noarch 7.2.1-2.fc34 fedora 5.3 M
proj-data-jp noarch 7.2.1-2.fc34 fedora 401 k
proj-data-nc noarch 7.2.1-2.fc34 fedora 1.1 M
proj-data-nl noarch 7.2.1-2.fc34 fedora 1.1 M
proj-data-nz noarch 7.2.1-2.fc34 fedora 13 M
proj-data-pt noarch 7.2.1-2.fc34 fedora 432 k
proj-data-se noarch 7.2.1-2.fc34 fedora 2.2 M
proj-data-sk noarch 7.2.1-2.fc34 fedora 1.2 M
proj-data-uk noarch 7.2.1-2.fc34 fedora 4.7 M
proj-data-us noarch 7.2.1-2.fc34 fedora 223 M
Transaction Summary
================================================================================
Install 26 Packages
Total download size: 593 M
Installed size: 766 M
Is this ok [y/N]: yMethod 2: Install Mysql Workbench on Fedora 36/35/34/33/32 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.socketEnable 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) installed#2) Use Mysql Workbench on Fedora 36/35/34/33/32
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 36/35/34/33/32. There are many more management activities you can do to a database with MySQL Workbench. I hope this guide was helpful.
