Welcome to Debian Tutorial. In this article, you will learn how to install MySQL Workbench on Debian 9. The new version of MySQL Workbench 6.3.10 is now available for download. MySQL Workbench is a GUI tool to manage MySQL Server. You can use this tool to manage your MySQL Server installed locally or remotely. It has many important tools you need to create, edit, delete databases, create and edit users, tables and many more. Its a must-have tool for MySQL users.
What will you learn?
- Install MySQL Workbench 6.3.10
- Connect to MySQL Server
Steps to install MySQL Workbench on Debian 9
First, let’s download MySQL Workbench DEB file for Debian. Please navigate to this download page and make sure you select the Ubuntu Linux from the Operating System list. Make sure you download the Ubuntu 16.04 version.
Install the DEB package.
Once you download the file, you should have a file called: mysql-workbench-community-6.3.10-1ubuntu16.04-amd64.deb
Open Terminal and then execute this command to install the package
sudo -i dpkg -i mysql-workbench-community-6.3.10-1ubuntu16.04-amd64.deb
Mostly, you will end up with the following errors:
dhani@dhani-thinkpad:~/Downloads$ sudo dpkg -i mysql-workbench-community-6.3.10-1ubuntu17.10-amd64.deb [sudo] password for dhani: Selecting previously unselected package mysql-workbench-community. (Reading database ... 204990 files and directories currently installed.) Preparing to unpack mysql-workbench-community-6.3.10-1ubuntu17.10-amd64.deb ... Unpacking mysql-workbench-community (6.3.10-1ubuntu17.10) ... dpkg: dependency problems prevent configuration of mysql-workbench-community: mysql-workbench-community depends on libglibmm-2.4-1v5 (>= 2.54.0); however: Version of libglibmm-2.4-1v5:amd64 on system is 2.50.1-1. mysql-workbench-community depends on libgtkmm-3.0-1v5 (>= 3.22.0); however: Package libgtkmm-3.0-1v5 is not installed. mysql-workbench-community depends on libzip4 (>= 0.10); however: Package libzip4 is not installed. mysql-workbench-community depends on python-paramiko (>= 1.15.1); however: Package python-paramiko is not installed. dpkg: error processing package mysql-workbench-community (--install): dependency problems - leaving unconfigured Processing triggers for lastore-daemon (0.9.61-1) ... Processing triggers for desktop-file-utils (0.23-2) ... Processing triggers for bamfdaemon (0.5.3-2) ... Rebuilding /usr/share/applications/bamf-2.index... Processing triggers for mime-support (3.60) ... Processing triggers for hicolor-icon-theme (0.15-1) ... Processing triggers for shared-mime-info (1.8-1) ... Errors were encountered while processing: mysql-workbench-community
Now let’s fix the errors:
apt-get -f install
Once completed, you can now use MySQL Workbench to connect to your MySQL or MariaDB Server.