Install MySQL Workbench on CentOS 7

Install EPEL (Extra Packages for Enterprise Linux) repositories:

wget https://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm
sudo yum install ./epel-release-7-5.noarch.rpm

Install MySQL repositories:

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
wget http://repo.mysql.com/mysql-community-release-el7.rpm
sudo yum install ./mysql-community-release-el7.5.noarch.rpm
sudo yum install ./mysql-community-release-el7.rpm 

(installing mysql-community-release-el7.rpm produced error: “does not update installed package”)

Install MySQL Workbench.

sudo yum install mysql-workbench

Install additional dependencies (that you would be informed of in error messages, if you invoked mysql-workbench

sudo yum install libzip.x86_64
sudo yum install tinyxml.x86_64

You can now start MySQL Workbench using menu: Applications / Programming / MySQL Workbench

References

  • http://www.cyberciti.biz/faq/installing-rhel-epel-repo-on-centos-redhat-7-x/
  • http://www.linuxpcfix.com/how-to-install-and-configure-mysql-workbench-on-linux-system/

12 Replies to “Install MySQL Workbench on CentOS 7”

  1. Hi,
    After I installed CentOS 7 and MariaDB I followed your installation Workbench steps and all worked pretty good.
    MariaDB Server
    MySQL WorkBench
    phpMyAdmin
    Nicely without any interaction/interruption they worked simultaneously.
    But if I “yum update” or “reboot with installing updates” replaced MariaDB Server with MySQL Server.
    CentOS guys told me remove the MySQL repositories to eliminate this. But I want to have MySQL WorkBench.
    Funny CentOS enforcement not to have MySQL server but MariaDB Server at the installation fails with the first update.
    Trying not to install with playing with the repositories is a very dangerous game in a production environment. Up until MariaDB has all and not crisscrossing with MySQL, CentOS sould not force to install MariaDB at the initial install without any warning that crisscrossing will replace the server…
    http://bugs.centos.org/view.php?id=8328
    I did not have chance to post my “yum repolist” in this bug-report.
    Here it is:
    yum repolist
    Loaded plugins: fastestmirror, langpacks
    Determining fastest mirrors
    * base: centos.mirrors.tds.net
    * epel: mirror.cogentco.com
    * extras: centos.chi.host-engine.com
    * nux-dextop: li.nux.ro
    * rpmforge: repoforge.spinellicreations.com
    * updates: mirrors.einstein.yu.edu
    adobe-linux-x86_64 2/2
    repo id repo name status
    !adobe-linux-x86_64 Adobe Systems Incorporated 2
    !base/7/x86_64 CentOS-7 – Base 8,465
    !epel/x86_64 Extra Packages for Enterprise Linux 7 7,454
    !extras/7/x86_64 CentOS-7 – Extras 104
    !mysql-connectors-community/x86_64 MySQL Connectors Community 13
    !mysql-tools-community/x86_64 MySQL Tools Community 15
    !mysql56-community/x86_64 MySQL 5.6 Community Server 124
    !nux-dextop/x86_64 Nux.Ro RPMs for general desktop use 1,886
    !rpmforge RHEL 7 – RPMforge.net – dag 245
    !updates/7/x86_64 CentOS-7 – Updates 1,725
    repolist: 20,033

  2. I had the same issue – and the following worked for me:

    [root@AS400-forge ~]# yum remove mysql-community-release
    Loaded plugins: fastestmirror, langpacks
    Resolving Dependencies
    –> Running transaction check
    —> Package mysql-community-release.noarch 0:el7-5 will be erased
    –> Finished Dependency Resolution

    Dependencies Resolved

    ===============================================================================================================================================
    Package Arch Version Repository Size
    ===============================================================================================================================================
    Removing:
    mysql-community-release noarch el7-5 installed 4.3 k

    Transaction Summary
    ===============================================================================================================================================
    Remove 1 Package

    Installed size: 4.3 k
    Is this ok [y/N]: y
    Downloading packages:
    Running transaction check
    Running transaction test
    Transaction test succeeded
    Running transaction
    Erasing : mysql-community-release-el7-5.noarch 1/1
    Verifying : mysql-community-release-el7-5.noarch 1/1

    Removed:
    mysql-community-release.noarch 0:el7-5

    Complete!
    [root@AS400-forge ~]# yum update
    Loaded plugins: fastestmirror, langpacks
    Loading mirror speeds from cached hostfile
    * base: mirror.sov.uk.goscomb.net
    * epel: http://ftp.nluug.nl
    * extras: mirror.sov.uk.goscomb.net
    * nux-dextop: mirror.li.nux.ro
    * updates: mirror.vorboss.net
    Resolving Dependencies
    –> Running transaction check
    —> Package python-qrcode-core.noarch 0:5.0.1-1.el7 will be updated
    —> Package python-qrcode-core.noarch 0:5.0.1-2.el7 will be an update
    –> Finished Dependency Resolution

    Dependencies Resolved

    ===============================================================================================================================================
    Package Arch Version Repository Size
    ===============================================================================================================================================
    Updating:
    python-qrcode-core noarch 5.0.1-2.el7 epel 40 k

    Transaction Summary
    ===============================================================================================================================================
    Upgrade 1 Package

    Total download size: 40 k
    Is this ok [y/d/N]: y
    Downloading packages:
    No Presto metadata available for epel
    python-qrcode-core-5.0.1-2.el7.noarch.rpm | 40 kB 00:00:00
    Running transaction check
    Running transaction test
    Transaction test succeeded
    Running transaction
    Updating : python-qrcode-core-5.0.1-2.el7.noarch 1/2
    Cleanup : python-qrcode-core-5.0.1-1.el7.noarch 2/2
    Verifying : python-qrcode-core-5.0.1-2.el7.noarch 1/2
    Verifying : python-qrcode-core-5.0.1-1.el7.noarch 2/2

    Updated:
    python-qrcode-core.noarch 0:5.0.1-2.el7

    Complete!

  3. Followed the instructions explicitly. Got “Segmentation Fault” with a long backtrace, hitting “libpthread.so.0” first

    Too bad the Linux desktop people can’t get caught up to 1995 or so. It is really dissapointing to have to reboot into the Windows partition to get anything done.

      1. Thanks for the update Enric. The package manifest might also have been updated. I’ve have since gone back to Windows for my desktop OS and FreeBSD for servers (on a local vm for testing). It’s the best compromise I’ve found for my workflow.

  4. Hello,

    When I’m trying “sudo yum install ./mysql-community-release-el7.5.noarch.rpm”

    I’m getting:
    “No package ./mysql-community-release-el7.5.noarch.rpm available.”

    However wget outputs “‘mysql-community-release-el7-5.noarch.rpm.1’ saved ”

    And same for the second package. Please help. Thank you in advance.

    1. Sorry but I can’t offer suggestions. Recently I’ve been working on embedded devices and haven’t installed MySQL for some time now. Best luck solving your problem.

    2. It says “No package ./mysql-community-release-el7.5.noarch.rpm available.” because wget downloads the package *el7-5.noarch.rpm . just substitute dot with the dash

    1. You will have to search for the new location or revision. Some of the previous comments may also help or give direction. I haven’t used MySQL Workbench for several years, but will update the post if one day I again have the need. Sorry I can’t help further.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.