MySQL Workbench is a GUI tool to manage MySQL Server. It comes with many features to administer multiple MySQL or MariaDB server remotely. We can create new database, tables, edit table, create query, export and import data using this Workbench. This tutorial is going to show you how to install MySQL Workbench on Linux Mint 18. Before we go through the installation process. You may want to have a look at the new MySQL Workbench running on Linux Mint 18. When this article is being written, MySQL Workbench 6.3.1 is available from the official website.
MySQL Workbench Screenshots on Linux Mint 18
Click the following image to see the larger version.
Steps to install MySQL Workbench on Linux Mint 18
Step 1. Download MySQL Workbench DEB
First, we need to download the installation file of MySQL Workbench for Ubuntu 16.04. Please use the following link to download the file.
Make sure you choose Ubuntu Linux from the Operating System list.
Now save the DEB file to your local directory. You should have a file name: mysql-workbench-community-6.3.10-1ubuntu16.04-amd64.deb
Step 2. Install MySQL Workbench
Now, open File Manager and right click on the DEB file. Select Open With GDebi Package Installer to start the installation.
Next, click Install Package and then enter your root password
Wait until the installation process is complete.
Now you should see MySQL Workbench on your application menu. You can find it under Programming. Click it to open.
Create new MySQL Connection
After we install MySQL Workbench, we need to connect our MySQL Server. Open Workbench and then click + button close to MySQL Connection on its main window. It will open up a new connection window. Enter your MySQL Server details including IP address, user and password.
Click OK to complete this step and you can now working with your MySQL Server.
MySQL Workbench is a must have tool for MySQL Server administrator. It can be installed on Windows and Linux as well. You can manage multiple MySQL Servers from remotely. It comes with great built in tools you need. Thanks for reading this how to install MySQL Workbench on Linux Mint. See you on the next tutorial.