Install and Use Mysql Workbench on Fedora 36/35/34/33

Posted on 132 views

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 update

Install 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.rpm

Once 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-workbench

Sample 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]: y

Method 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 snapd

Star and enable snap on Fedora

sudo systemctl enable --now snapd.socket

Enable classic snap support.

sudo ln -s /var/lib/snapd/snap /snap

Now 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-workbench

Alternatively use the App Menu as below:

Install-and-Use-Mysql-Workbench-on-Fedora-35343332-1

MySQL Workbench will start as below:

Install-and-Use-Mysql-Workbench-on-Fedora-35343332

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.

Install-and-Use-Mysql-Workbench-on-Fedora-35343332-2

Provide a password for the local instance connection.

Install-and-Use-Mysql-Workbench-on-Fedora-35343332-3

On successful authentication, you will see this admin dashboard.

Install-and-Use-Mysql-Workbench-on-Fedora-35343332-4

Check the connected database server status:

Install-and-Use-Mysql-Workbench-on-Fedora-35343332-5

Manage users and privileges as below.

Install-and-Use-Mysql-Workbench-on-Fedora-35343332-6

Assid from the administration, you can switch to the schemas tab.

Install-and-Use-Mysql-Workbench-on-Fedora-35343332-7

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.

Install-and-Use-Mysql-Workbench-on-Fedora-35343332-8

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.

coffee

Gravatar Image
A systems engineer with excellent skills in systems administration, cloud computing, systems deployment, virtualization, containers, and a certified ethical hacker.