2.4.1 Installing

There are binary distributions of MySQL Workbench available for several variants of Linux, including Fedora, Oracle Linux, and Ubuntu. For general requirements and specific installation instructions, see the sections that follow.

The procedure for installing on Linux depends on which Linux distribution you are using. Select one of the following installation methods:

Official MySQL Yum or APT repository packages

These binaries are built by the MySQL Release team. For additional information about installing these, see Yum or APT. They contain the newest versions of MySQL Workbench. Typically this package is named mysql-workbench-community.

Your Linux distributions repository packages

These binaries are built and maintained by members of the Linux distribution you use, and not by the MySQL team. They are stable but the releases often lag behind. Typically this package is named mysql-workbench.

Download official MySQL packages

Downloads are available at https://dev.mysql.com/downloads/workbench.

Download the source code and compile yourself

The source code is available at https://dev.mysql.com/downloads/workbench as a tar.gz or RPM package.

Note

A change in the %cmake macro causes an error to occur when MySQL Workbench is built from source code on Fedora 33 using the RPM package. To avoid the error, use the new %cmake_build macro.

Requirements for Linux

  • The requirements for Linux are embedded within their respective packages. Use the platform specific tool (for example, yum or apt) to install the package and their dependencies.

  • The Save password in vault functionality requires gnome-keyring-daemon to store the passwords. Note that KDE systems use their own ksecretservice implementation.

  • For Linux and macOS, the MySQL server administration features require sudo command privileges to execute several commands. The sudo user must be capable of executing the following system commands:

    /usr/bin/sudo
    /usr/bin/nohup
    /usr/bin/uptime
    /usr/bin/which
    /usr/bin/stat
    
    /bin/bash
    /bin/mkdir
    /bin/rm
    /bin/rmdir
    /bin/dd
    /bin/cp
    /bin/ls

    Additionally, the sudo user must keep the HOME environment variable when executing system commands, which means adding the following entry to the /etc/sudoers file safely by using the visudo command:

    Defaults env_keep +="HOME"

    For MySQL Workbench to execute MySQL Enterprise Backup commands, the sudo command user must also be able to execute the MySQL Enterprise Backup binary.

Installing DEB Packages

On Ubuntu, and other systems that use the Debian package scheme, you can either download and install .deb packages or use the APT package manager.

Using the APT Package Manager

Important

Your Linux distribution includes MySQL Workbench builds for which the command "apt-get install mysql-workbench" installs their build of the MySQL Workbench package. To use the official MySQL Workbench builds as provided by the MySQL Release team, you must install the official MySQL APT repository and choose the "mysql-workbench-community" package instead of "mysql-workbench".

  1. Install the MySQL APT repository as described in the MySQL APT Repository documentation. For example:

    shell> sudo dpkg -i mysql-apt-config_0.5.3-1_all.deb
    shell> sudo apt-get update
  2. Install the MySQL Workbench package. There might be multiple Workbench packages available, so specify the exact version to install such as mysql-workbench-community. For example:

    shell> sudo apt-get install mysql-workbench-community

Installing a Package Manually

You install MySQL Workbench using a command such as:

shell> sudo dpkg -i package.deb

In the previous example, package.deb is the MySQL Workbench package name; for example, mysql-workbench-community-version1ubu1404-amd64.deb, where version is the MySQL Workbench version number.

Note

You might be warned that certain libraries are not available, depending on what you already have installed. If such a warning interrupts the installation, install the required libraries first and then install the MySQL Workbench package again.

Installing RPM Packages

On Red Hat-based systems, and other systems that use the RPM package format, you can either download and install RPM packages or use the Yum package manager.

Note

Enterprise Linux systems, such as Oracle Linux and Red Hat, may require access to the EPEL package repository. For additional information about installing EPEL, see Installing Oracle Enterprise Linux and Similar.

Using the Yum Package Manager

Your Linux distribution includes MySQL Workbench builds for which the command "yum install mysql-workbench" installs their build of the MySQL Workbench package. To use the official MySQL Workbench builds as provided by the MySQL Release team, you must install the official MySQL Yum repository and choose the "mysql-workbench-community" package instead of "mysql-workbench".

  1. Install the MySQL Yum repository as described in the MySQL Yum Repository documentation. For example:

    shell> sudo rpm -Uvh mysql-community-release-el7-7.noarch.rpm
  2. Install the MySQL Workbench package. There might be multiple MySQL Workbench packages available, so specify the exact version to install such as mysql-workbench-community. For example:

    shell> sudo yum install mysql-workbench-community

Installing a Package Manually

shell> sudo rpm -i package.rpm

In the previous example, package.rpm is the MySQL Workbench package name; for example, mysql-workbench-community-version-1fc10.x86_64.rpm, where version is the MySQL Workbench version number.

Installing Oracle Enterprise Linux and Similar

MySQL Workbench requires access to the EPEL repository only if you are working with spatial data, but not for general use. Earlier versions of MySQL Workbench (before 8.0.18) require access to it for all use cases. EPEL is a repository with additional RPM packages that are not part of the core RHEL/OEL distribution. This includes packages (such as tinyxml) that MySQL Workbench requires.

You need to set up the EPEL repository in yum to resolve the required dependencies. For example, using Oracle Linux 6.8 you would:

shell> wget http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
shell> rpm -ivh epel-release-6-8.noarch.rpm

shell> yum repolist

Loaded plugins: refresh-packagekit, rhnplugin
repo id                repo name                                          status
epel                   Extra Packages for Enterprise Linux 6 - x86_64      7,124

These instructions also apply to similar Linux distributions such as Red Hat Enterprise Linux, CentOS, and Scientific Linux.

Next, follow the RPM-based installation documentation at Installing RPM Packages.