Home » Msyql » How to install and configure MySQL workbench on linux system

How to install and configure MySQL workbench on linux system

Install mysql workbench 5.6

MySQL Workbench is a combined and most useful visual tool for developers, database architects, and database administrators. MySQL Workbench provides data modeling, data designing SQL development, and wide-ranging administration tools for server configuration, user administration, data backup, and other useful tools. MySQL Workbench is available for Windows, Linux and Mac OS X. This article will guide to install MySQL Workbench on Centos/RHEL system.
Requirements for Linux

The following libraries must be installed on your linux server
ConsoleKit ConsoleKit-libs GConf2 ORBit2 atk avahi-libs cairo cairomm cups-libs dbus eggdbus fontconfig freetype glibmm24 gnome-keyring gnutls gtk2 gtkmm24 hicolor-icon-theme jasper-libs libICE libIDL libSM libX11 libX11-common libXau libXcomposite libXcursor libXdamage libXext libXfixes libXft libXi libXinerama libXrandr libXrender libXxf86vm libjpeg-turbo libpng libsigc++20 libthai libtiff libxcb libzip mesa-dri-drivers mesa-dri-filesystem mesa-dri1-drivers mesa-libGL mesa-private-llvm pango pangomm pixman polkit python-crypto python-paramiko sgml-common

MySQL provides Yum repository for Centos, Fedora, RHEL platform:

Install mysql yum repository on your system
Centos 7

[root@linuxpcf ~]#wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
[root@linuxpcf ~]#wget http://repo.mysql.com/mysql-community-release-el7.rpm

Centos 6.5

[root@linuxpcf ~]#wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

Centos 6.4

[root@linuxpcf ~]#wget http://repo.mysql.com/mysql-community-release-el6-4.noarch.rpm

Centos 5

[root@linuxpcf ~]#wget http://repo.mysql.com/mysql-community-release-el5.rpm

In this article we are using Centos 6.5

[root@linuxpcf ~]#rpm -Uvh http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
Retrieving http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
Preparing… ########################################### [100%]
1:mysql-community-release########################################### [100%]
[root@linuxpcf ~]# yum install mysql-workbench
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.nbrc.ac.in
* extras: mirror.nbrc.ac.in
* updates: mirror.nbrc.ac.in
mysql-connectors-community | 2.13 kB 00:00
mysql-connectors-community/primary_db | 7.0 kB 00:00
mysql-tools-community | 2.13 kB 00:00
mysql-tools-community/primary_db | 16 kB 00:00
mysql56-community | 2.13 kB 00:00
mysql56-community/primary_db | 59 kB 00:00
Setting up Install Process
Resolving Dependencies
–> Running transaction check
—> Package mysql-workbench-community.x86_64 0:6.2.3-1.el6 will be installed
–> Processing Dependency: gtk2 >= 2.20 for package: mysql-workbench-community-6.2.3-1.el6.x86_64
–> Processing Dependency: python-paramiko for package: mysql-workbench-community-6.2.3-1.el6.x86_64
–> Processing Dependency: libpng12.so.0(PNG12_0)(64bit) for package: mysql-workbench-community-6.2.3-1.el6.x86_64
–> Processing Dependency: libjpeg.so.62(LIBJPEG_6.2)(64bit) for package: mysql-workbench-community-6.2.3-1.el6.x86_64
—> Package ConsoleKit-libs.x86_64 0:0.4.1-3.el6 will be installed
–> Finished Dependency ResolutionDependencies Resolved======================================================================================================================================
Package                                                  Arch                                Version                                        Repository                                          Size
======================================================================================================================================
Installing:
mysql-workbench-community      x86_64                             6.2.3-1.el6                                mysql-tools-community                  18 M
Installing for dependencies:
ConsoleKit                                         x86_64                              0.4.1-3.el6                                 base                                                     82 k
ConsoleKit-libs                                x86_64                              0.4.1-3.el6                                 base                                                     17 k
GConf2                                               x86_64                              2.28.0-6.el6                              base                                                     964 kTransaction Summary
======================================================================================================================================
Install 57 Package(s)Total download size: 46 M
Installed size: 220 M
Is this ok [y/N]: y
Downloading Packages:
(1/57): ConsoleKit-0.4.1-3.el6.x86_64.rpm | 82 kB 00:00
(2/57): ConsoleKit-libs-0.4.1-3.el6.x86_64.rpm | 17 kB 00:00
(3/57): GConf2-2.28.0-6.el6.x86_64.rpm | 964 kB 00:00
(4/57): ORBit2-2.14.17-3.2.el6_3.x86_64.rpm | 168 kB 00:00
(5/57): atk-1.30.0-1.el6.x86_64.rpm | 195 kB 00:00
(6/57): avahi-libs-0.6.25-12.el6_5.3.x86_64.rpm | 55 kB 00:00
libXrandr.x86_64 0:1.4.0-1.el6 libXrender.x86_64 0:0.9.7-2.el6
libXxf86vm.x86_64 0:1.1.2-2.el6 libjpeg-turbo.x86_64 0:1.2.1-3.el6_5
libpng.x86_64 2:1.2.49-1.el6_2 libsigc++20.x86_64 0:2.2.4.2-1.el6
libthai.x86_64 0:0.1.12-3.el6 libtiff.x86_64 0:3.9.4-10.el6_5
Complete!

If you want to install the through RPM package then go through by following steps.
Centos 6

[root@linuxpcf ~]# wget http://cdn.mysql.com/Downloads/MySQLGUITools/mysql-workbench-community-6.2.3-1.el6.x86_64.rpm
–2014-10-09 02:43:11– http://cdn.mysql.com/Downloads/MySQLGUITools/mysql-workbench-community-6.2.3-1.el6.x86_64.rpm
Resolving cdn.mysql.com… 23.211.164.51
Connecting to cdn.mysql.com|23.211.164.51|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 19289152 (18M) [application/x-redhat-package-manager]
Saving to: “mysql-workbench-community-6.2.3-1.el6.x86_64.rpm”100%[============================================================================================>] 19,289,152 4.12M/s in 5.7s2014-10-09 02:43:17 (3.22 MB/s) – “mysql-workbench-community-6.2.3-1.el6.x86_64.rpm” saved [19289152/19289152]
[root@linuxpcf ~]#rpm -ivh mysql-workbench-community-6.2.3-1.el6.x86_64.rpm

Centos 7

[root@linuxpcf ~]#wget http://cdn.mysql.com/Downloads/MySQLGUITools/mysql-workbench-community-6.2.3-1.el7.x86_64.rpm
[root@linuxpcf ~]#rpm -ivh mysql-workbench-community-6.2.3-1.el7.x86_64.rpm

Note :: We recommand use the yum tool to install mysql-workbench instead of RPM package because yum will resolve all dependencies automatically.
Once the installation get completed successfully then access the MySQL Workbench followed by below images.
mysql-bench1

mysql-bench2

mysql-bench3
I hope this article will help you to accomplish the installation of MySQL Workbench on Centos Server.
Have a nice day!

About

I am founder and webmaster of www.linuxpcfix.com and working as a Sr. Linux Administrator (Expertise on Linux/Unix & Cloud Server) and have been in the industry from last 7 years.

Leave a Reply

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

*
*

Time limit is exhausted. Please reload the CAPTCHA.

Categorized Tag Cloud