MySQL Workbench

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.

Installation options include:

The procedure for installing on Linux depends on which Linux distribution you are using.

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 where "apt-get install mysql-workbench" will install 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".

  • First, 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
    
  • Next, install MySQL Workbench. You might have multiple Workbench packages available, so choose the "mysql-workbench-community" version. 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

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 may be warned that certain libraries are not available, depending on what you already have installed. Install the required libraries 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 where "yum install mysql-workbench" will install 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".

  • First, 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
    
  • Next, install MySQL Workbench. You might have multiple Workbench packages available, so choose the "mysql-workbench-community" version. For example:

    shell> sudo yum install mysql-workbench-community
    

Manually Installing a Package

shell> sudo rpm -i package.rpm

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.