How to install Mysql Workbench on Ubuntu
To install Mysql Workbench on Ubuntu
MySQL Workbench is a visual tool used by database developers and architects to manage MySQL Database. In our previous article, we covered the installation of MySQL Workbench on Debian 8.3. In this article, we will learn the method to install MySQL Workbench on Ubuntu.
Installing Workbench
Before starting the installation, visit the official site of MySQL workbench: https://dev.mysql.com/downloads/workbench/ and download Debian package from the listed options.
Once it is done, move to the downloads directory by using the following command.
root@linuxhelp:~# cd Downloads/
root@linuxhelp:~/Downloads# ls
mysql-workbench-community-6.3.9-1ubuntu16.04-amd64.deb
The package is in debian(.deb) format so install it using offline package manager command like dpkg, we recommend you to install it using gdebi command.
Since gdebi is not currently installed on Ubuntu, let us install it first. Use the following command for the same purpose.
root@linuxhelp:~/Downloads# apt-get install gdebi -y
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
gdebi
0 upgraded, 1 newly installed, 0 to remove and 2 not upgraded.
Need to get 0 B/23.6 kB of archives.
After this operation, 169 kB of additional disk space will be used.
Selecting previously unselected package gdebi.
(Reading database ... 183019 files and directories currently installed.)
Preparing to unpack .../gdebi_0.9.5.7ubuntu1_all.deb ...
Unpacking gdebi (0.9.5.7ubuntu1) ...
Processing triggers for gnome-menus (3.13.3-6ubuntu3)
.
.
.
Processing triggers for man-db (2.7.5-1) ...
Setting up gdebi (0.9.5.7ubuntu1) ...
root@linuxhelp:~/Downloads# ls
mysql-workbench-community-6.3.9-1ubuntu16.04-amd64.deb
All is now set for the installation of MySQL Workbench. Install it using gdebi command as follows.
root@linuxhelp:~/Downloads# gdebi mysql-workbench-community-6.3.9-1ubuntu16.04-amd64.deb
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading state information... Done
Requires the installation of the following packages: libaec0 libgeos-3.5.0 libgeos-c1v5 libgfortran3 libhdf4-0-alt libhdf5-10 libmysqlclient20 libnetcdf11 libpcrecpp0v5 libpq5 libsz2 libxerces-c3.1 libzip4 mysql-common python-crypto python-ecdsa python-paramiko python-six
MySQL Workbench
MySQL Workbench is development, administration and data modeling tool
.
.
.
Setting up mysql-workbench-community (6.3.9-1ubuntu16.04) ...
Processing triggers for shared-mime-info (1.5-2) ...
Processing triggers for hicolor-icon-theme (0.15-0ubuntu1) ...
Processing triggers for gnome-menus (3.13.3-6ubuntu3) ...
Processing triggers for desktop-file-utils (0.22-1ubuntu5) ...
Processing triggers for bamfdaemon (0.5.3~bzr0+16.04.20160415-0ubuntu1) ...
Rebuilding /usr/share/applications/bamf-2.index...
Processing triggers for mime-support (3.59ubuntu1) ...
MySQL workbench has been installed successfully. When you launch the application, it appears on your screen as follows.
Wasn' t it simple to install? MySQL Workbench has a plethora of uses. MySQL Workbench is used for several purposes such as SQL Development as it enables the users to connect with the database servers and to access it, Data modeling and design, server administrations, data migration, and MySQL Enterprise Support which includes MySQL Enterprise Backup, MySQL Firewall, and MySQL Audit.
The SQL statement history is stored as plain text on your system under your user's MySQL Workbench config
# mysqldump (CurrentDB-name) (Backup-name).sql