If I tried to install libgdal1i, it will show The following packages have unmet dependencies: libgdal1i : Depends: Recommends: mysql-utilities but it is not going to be installedĮ: Unable to correct problems, you have held broken 表明 The following packages have unmet dependencies: mysql-workbench :ĭepends: libgdal1i (>= 1.8.0) but it is not going to be installed For get more information about this project, users can go to the project website or its documentation.I looked around the several answer but none solved my problem.įirst, I tried sudo apt install mysql-workbench -f. Everyone can find the one that best suits their way of working. This is quite simple to use, but it is just one more option of the many that exist. Today, in Gnu / Linux there are many possibilities to work with databases. Sudo snap remove mysql-workbench-community Snap connect mysql-workbench-community:removable-media Uninstallįor, remove this program from our team, in a terminal (Ctrl + Alt + T) it is only necessary to write the command: 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:ssh-keys 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 So it is necessary to grant this permission explicitly.
Once everything is written correctly, you are all set to go.Īs 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. Once there, we just have to set up a new connection, typing the credentials of the database server and testing the connection. We can also add a new connection by clicking on the ⊕ sign that we can find next to ' MySQL connections'. To connect to a database server, we just have to click on Database = Connect to database. In addition, we can also start the program by searching for the launcher that we will be able to find available in our team. Once the installation is complete, we can start this program from command line typing: Sudo snap install mysql-workbench-community If you choose to use this last option, you will only need to write the installation command in it:
To perform the community version installation, we can use either the Ubuntu software option, or the terminal (Ctrl + Alt + T). Today, the Workbench package cannot be found in the Ubuntu repository as of Ubuntu 20.04, so using this installation option is something that can help us. But in the following lines we will see how install MySQL Workbench on Ubuntu using the snap pack. Users can install Workbench and use it in other Gnu / Linux distributions, not just Ubuntu. Install MySQL Workbench as Snap Package on Ubuntu 1 Install MySQL Workbench as Snap Package on Ubuntu.Workbench will also work with MariaDB databases as MariaDB is a direct replacement for MySQL. 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. MySQL Workbench makes it easy to manage your MySQL database, whether you are a new user or a professional. This program supports database and user management, creating and executing SQL queries, configuring servers, performing backups, performing migrations, and much more. Oracle also distributes an open source Community Edition, which is available for free. It is developed and distributed by Oracle Corporation, and is available in various commercial editions for business use.
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.Īs already commented on Another item published on this blog, MySQL Workbench is a graphical environment for working with MySQL databases and servers. This is a software that can be used to manage MySQL databases from a local or remote machine. In the next article we are going to take a look at how we can install MySQL Workbench on Ubuntu using its snap package.