MySQL is a giant in today’s database managers. While it is true that lost some strength after the birth of MariaDB. However, even the MySQL brand is quite well known. If we add to this that the new version of MySQL contemplates many improvements for the business environment, then we can say that it is still a solid alternative to payment solutions such as Oracle or Microsoft SQL server. Part of MySQL’s potential lies in its administrative tool called MySQL Workbench. In it you will be able to completely manage a MySQL instance, then it becomes vital to install it. So, in this post, you will learn how to install MySQL Workbench on Ubuntu 18.04 / Linux Mint 19.
MySQL Workbench is perhaps the best in the class
When you have the MySQL server correctly configured and working, there is no way to manage that data on the client side. To do this, we show you many alternatives in our post on Graphical Clients for SQL. However, MySQL Workbench is the official MySQL client.
On the other hand, Workbench is not only limited to the data visualization as in the rest of programs, but it is also an administrative tool of the MySQL instance. With it, you can also model databases and in turn, perform reverse engineering processes. All this, for free and with support to our favorite operating system.
Also, there are two ways to install it, so I will show you how to do it.
Install MySQL Workbench using the Ubuntu repository
MySQL Workbench to be an application so useful and necessary within the management of MySQL that is available from the main repository of Ubuntu and therefore in Linux Mint. The problem here is that Ubuntu 18.04 was released a year ago and many of these applications are already obsolete. They may be useful for some cases, but given the new features of MySQL 8, it’s a good idea to keep it up to date.
However, to install the repository version, open a terminal and type the following:
:~$ sudo apt search mysql-workbench p mysql-workbench p mysql-workbench:i386 p mysql-workbench-data
And install MySQL Workbench by using this command:
:~$ sudo apt install mysql-workbench
The version that will be installed is 6.3.8 but version 8 is already available.
Install MySQL Workbench from the MySQL website
As I mentioned earlier, MySQL Workbench is a sensitive program that must be installed on the client. Therefore, it is convenient to enjoy its latest features, so it is convenient to have it updated.
The way to do this is to install the package that provides MySQL on the website. To do this, go to this page and select the package for Ubuntu Linux and download.
As you can see in the image, the version we will install is 8.0.16. There are differences, aren’t there? 🙂
Then, in the terminal type the following:
:~$ sudo gdebi [File_Path]
Now, launch it from the main menu.
So, enjoy it.
Conclusion
MySQL Workbench is perhaps the best for managing a MySQL instance. Its installation is simple but very valuable to get the most out of MySQL. Although it is not only limited to data query we can use it to model database.
Please share this post, and tell us your experience with this program.
