Install MySQL Workbench on Ubuntu 14.04 and CentOS 6

I will show you the installation of MySQL workbench on Ubuntu 14.04 and CentOS 6 which is good tool for managing database.

Let’s start Installation of MySQL Workbench.

– Download, Install & Update MySQL WorkBench Repository Package for Ubuntu 14.04

You can download the package using below command.

1 2 3 4

devops@devopsservice:~$ wget http://dev.mysql.com/get/mysql-apt-config_0.3.5-1ubuntu14.04_all.deb devops@devopsservice:~$

Install Package using dpkg command

1 2 3

devops@devopsservice:~$ sudo dpkg -i mysql-apt-config_0.3.5-1ubuntu14.04_all.deb

Update Repository

1 2 3

devops@devopsservice:~$ sudo apt-get update -y

Install MySQL Workbench package using apt-get

1 2 3

devops@devopsservice:~$ sudo apt-get install mysql-workbench-community -y

During Installation it will ask Which MySQL product do you wish to configure. Select Workbench.

Next It will ask Which Server version do you wish to receive. Select workbench-6.3

In Next Screen click on apply.

Check version of MySQL workbench

1 2 3 4 5

devops@devopsservice:~$ mysql-workbench --version MySQL Workbench CE (GPL) 6.3.4 0  build 828 devops@devopsservice:~$

– Download, Install & Update MySQL Workbench Repository Package for CentOS 6

You can download the package using below command

1 2 3 4

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

Install Package using rpm command

1 2 3 4

[root@centos ~]# rpm -ivh mysql-community-release-el6-5.noarch.rpm [root@centos ~]#

Install MySQL Workbench package using yum install

1 2 3 4 5 6 7 8 9 10 11

[root@centos ~]# sudo yum install mysql-workbench-community Error: ===== Error: Package: mysql-workbench-community-6.3.4-1.el6.x86_64 (mysql-tools-community)            Requires: tinyxml You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest [root@centos ~]#

If you get above error, follow below steps.

Add EPEL repository

1 2 3

[root@centos ~]# yum install epel-release

Install package tinyxml

1 2 3

[root@centos ~]# yum install tinyxml

Again install MySQL Workbench package using yum install

1 2 3

[root@centos ~]# sudo yum install mysql-workbench-community

Check version of MySQL workbench

1 2 3 4 5

[root@centos ~]# mysql-workbench --version MySQL Workbench CE (GPL) 6.3.4 0  build 828 [root@centos ~]#

Thanks for reading. Do let us know if you have any feedback/suggestions.

Let us know if you want us to write us on any particular topic. We will try our best.

Source By http://www.devopsservice.com/