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/