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.rpm
Centos 6.5
Centos 6.4
Centos 5
In this article we are using Centos 6.5
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
–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 ~]#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.
I hope this article will help you to accomplish the installation of MySQL Workbench on Centos Server.
Have a nice day!
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 since more than 14 years.
