☰
✕
✕

How to install MySQL workbench in Debian 8.3

To install MySQL workbench on Debian 8.3

MySQL workbench is a cross-platform tool used for accessing MySQL server and database. It is simple and easy to install tool. In this tutorial, let us see about the installation of MySQL workbench on Debian 8.3

Installing MySQL Workbench

In order to install MySQL Workbench, you need to add the repo on your source list file. Use the following command to open the file. 

root@linuxhelp:~# nano /etc/apt/sources.list

Add the following lines to the file. 

deb http://ftp.debian.org/debian/ stable main contrib non-free
deb http://ftp.de.debian.org/debian jessie main

Once it is done, update the apt source as follows. 

root@linuxhelp:~# apt-get update
Get:1 http://ftp.debian.org jessie-updates InRelease [145 kB]
Ign http://ftp.de.debian.org jessie InRelease           
Hit http://ftp.de.debian.org jessie Release.gpg         
Hit http://ftp.de.debian.org jessie Release
Hit http://ftp.de.debian.org jessie/main amd64 Packages   
Hit http://ftp.de.debian.org jessie/main Translation-en                  
Ign http://ftp.debian.org stable InRelease                               
Get:2 http://ftp.debian.org jessie-updates/main Sources [15.4 kB]
Get:3 http://ftp.debian.org jessie-updates/contrib Sources [32 B]
Get:4 http://ftp.debian.org jessie-updates/main amd64 Packages/DiffIndex [6,916 B]
Get:5 http://ftp.debian.org jessie-updates/contrib amd64 Packages [32 B]
Get:6 http://ftp.debian.org jessie-updates/contrib Translation-en [14 B]
Get:7 http://ftp.debian.org jessie-updates/main Translation-en/DiffIndex [2,704 B]
Hit http://ftp.debian.org stable Release.gpg
Hit http://ftp.debian.org stable Release
Hit http://ftp.debian.org stable/main amd64 Packages
Hit http://ftp.debian.org stable/contrib amd64 Packages
Hit http://ftp.debian.org stable/non-free amd64 Packages
Hit http://ftp.debian.org stable/contrib Translation-en
Hit http://ftp.debian.org stable/main Translation-en
Hit http://ftp.debian.org stable/non-free Translation-en
Fetched 170 kB in 6s (27.2 kB/s)                                               
Reading package lists... Done

Next install the MySQL Workbench by using apt-get install command.

root@linuxhelp:~# apt-get install mysql-workbench
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  libarmadillo4 libarpack2 libctemplate2 libdap11 libdapclient3 libdapserver7
  libdbd-mysql-perl libdbi-perl libepsilon1 libfreexl1 libgdal1h libgeos-3.4.2
  libgeos-c1 libhdf4-0-alt libhdf5-8 libkml0 libmysqlcppconn7 libnetcdfc7
  libogdi3.2 libpcrecpp0 libproj0 libspatialite5 libterm-readkey-perl
  liburiparser1 libvsqlitepp3 libxerces-c3.1 libzip2 mysql-client
  mysql-client-5.5 mysql-utilities mysql-workbench-data odbcinst
  odbcinst1debian2 proj-bin proj-data python-crypto python-ecdsa
  python-mysql.connector python-paramiko python-pyodbc python-pysqlite2
Suggested packages:
  libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl
  libhdf4-doc libhdf4-alt-dev hdf4-tools libnetcdf4 ogdi-bin python-crypto-dbg
  python-crypto-doc python-pysqlite2-doc python-pysqlite2-dbg
The following NEW packages will be installed:
  libarmadillo4 libarpack2 libctemplate2 libdap11 libdapclient3 libdapserver7
  libdbd-mysql-perl libdbi-perl libepsilon1 libfreexl1 libgdal1h libgeos-3.4.2
.
.
.
Setting up python-paramiko (1.15.1-1) ...
Setting up python-pyodbc (3.0.6-2) ...
Setting up python-pysqlite2 (2.6.3-3) ...
Setting up proj-bin (4.8.0-5) ...
Setting up odbcinst1debian2:amd64 (2.3.1-3) ...
Setting up libgdal1h (1.10.1+dfsg-8+b3) ...
Setting up mysql-workbench (6.2.3+dfsg-7) ...
Setting up odbcinst (2.3.1-3) ...
Processing triggers for libc-bin (2.19-18+deb8u7) ...


MySQL workbench has been installed, use your activities search bar to find and launch MySQL Workbench.

The MySQL workbench appears on your screen.

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.

Tag : MySQL Workbench
FAQ
Q
Does MySQL Workbench support the TLSv1.2 protocol?
A
Because TLSv1.2 requires OpenSSL, support for this protocol is available for MySQL Workbench Commercial Editions, and not for the Community Edition (which is compiled using yaSSL and supports
Q
How do I copy my saved MySQL connections in Workbench to a different computer?
A
From the main navigation menu, choose Tools, Configuration, and then Backup Connections to create a Zip file with your configured MySQL connections. Next, load this file into your new Workben
Q
How can I view my MySQL Workbench query history?
A
In bottom pane, change Action Output to History and then choose the appropriate date.

The SQL statement history is stored as plain text on your system under your user's MySQL Workbench config
Q
What do the column flag acronyms (PK, NN, UQ, BIN, UN, ZF, AI, G) in the MySQL Workbench Table Editor mean?
A
Checking these boxes will alter the table column by assigning the checked constraints to the designated columns. Hover over an acronym to view a description, and see the Section 8.1.10.2, “C
Q
How to export (save) a MySQL database to a text file?
A
Open a MySQL connection, and select Server from the main navigation menu and choose Data Export to open the data export wizard. Alternatively, choose Data Export from the left Management pane