MySQL Workbench, install this program as snap package

about Workbench snap

In the next article we are going to take a look at how we can install MySQL Workbench on Ubuntu using its snap package. This is a software that can be used to manage MySQL databases from a local or remote machine. It can be said that it is a unified visual tool for architects, developers and database administrators, which is available for Gnu / Linux, Windows and Mac OS X.

As already mentioned in another article published on this blog, MySQL Workbench is a graphical environment for working with MySQL databases and servers. This is developed and distributed by Oracle Corporation, and is available in various commercial editions for use at the enterprise level. Oracle also distributes an open source Community Edition, which is available for free.

This program supports database and user management, creating and executing SQL queries, configuring servers, performing backups, performing migrations, and much more. MySQL Workbench makes it easy to manage your MySQL database, whether you are a new user or a professional. It includes everything a data modeler needs to create complex ER models, and it also offers key features to accomplish difficult documentation and change management tasks that typically require a lot of time and effort. Workbench will also work with MariaDB databases as MariaDB is a direct replacement for MySQL.

MysqlWorkbench running

Install MySQL Workbench as Snap Package on Ubuntu

Users can install Workbench and use it in other Gnu / Linux distributions, not just Ubuntu. But in the following lines we will see how install MySQL Workbench on Ubuntu using the snap pack. Today, the Workbench package cannot be found in the Ubuntu repository as of Ubuntu 20.04, so using this installation option is something that may help us.

installation from Ubuntu software option

To perform the community version installation, we can use either the Ubuntu software option, or the terminal (Ctrl + Alt + T). If you choose to use this last option, you will only need to write the installation command in it:

Workbench Snap installation

sudo snap install mysql-workbench-community

Once the installation is complete, we can start this program from command line writing:

Mysql Workbench launcher

mysql-workbench-community

In addition, we can also start the program by searching for the launcher that we will be able to find available in our team.

To connect to a database server, we just have to click on Database == Connect to database. We can also add a new connection by clicking on the ⊕ sign that we can find next to ‘MySQL connections.

add connection

Once there, we just have to set up a new connection, typing the credentials of the database server and testing the connection. Once everything is written correctly, you are all set to go.

new database configuration

As indicated in the GitHub repository where the snap version of this program is published, if you use connections, Workbench uses Password Manager and ssh to work properly. So it is necessary to grant this permission explicitly. We can do this by opening a terminal (Ctrl + Alt + T) and typing the following commands in it, one by one:

snap connect mysql-workbench-community:password-manager-service

snap connect mysql-workbench-community:ssh-keys

In case you use files on external drives or also need to print files, it will be necessary to execute these commands in the terminal:

snap connect mysql-workbench-community:cups-control

snap connect mysql-workbench-community:removable-media

Uninstall

For remove this program from our team, in a terminal (Ctrl + Alt + T) it is only necessary to write the command:

uninstall Mysql Workbench snap

sudo snap remove mysql-workbench-community

Nowadays, in Gnu / Linux there are many possibilities to work with databases. This is quite simple to use, but it is just one more option of the many that exist. Everyone can find the one that best suits their way of working. For get more information about this project, users can go to the project website or his documentation.

Add Comment