We are committed to provide service 24 X 7

Deals, Shopping, Training, Tools

Learn how to – Install and Use Mysql Workbench on Fedora 38/37/36/35/34/33

Learn how to – Install and Use Mysql Workbench on Fedora 38/37/36/35/34/33.

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 update

Install MySQL MySQL 8.0 using the dedicated guide below.

#1) 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-1.noarch.rpm

##For Fedora 37
wget https://dev.mysql.com/get/mysql80-community-release-fc37-1.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-workbench

Sample Output:

....
Transaction Summary
======================================================================================================================================================================================================
Install  204 Packages

Total download size: 711 M
Installed size: 1.2 G
Is this ok [y/N]: y

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

After a successful installation of MySQL Workbench launch it from the terminal as below.

$ mysql-workbench

Alternatively 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:

Cart

Your Cart is Empty

Back To Shop