MySql environment for Linux includes data modeling, development, SQL parameter administration tools, user administration, backup / restore, and other features. Its ease of use and all these features make it a great choice for managing MySql databases. On Linux, you can install MySql Workbench in a variety of ways, including through the official packages. Installing the official Oracle repositories, using the default operating system repositories, or compiling packages from source are all options. So let’s take a quick look at the method of installing a MySQL desktop environment on Arch Linux.
Linux system requirements
- Linux prerequisites are included in their separate packages. Use a platform-specific tool (like yum or apt) to install the package and its dependencies.
- The gnome-keyring-daemon is required to store passwords in the “Save Password to Vault” function. It’s worth noting that KDE uses its own ksecretservice implementation.
- MySQL server management functions for Linux and macOS require command capability sudo to perform various operations.
In addition, the user sudo should preserve the HOME variable while performing system tasks, which is achieved by carefully editing the / etc / sudoers file with the visudo command:
Defaults env_keep +="HOME"
Installing MySQL Workbench is straightforward: the package is part of the official Ubuntu repository. We can use the Distribution Package Manager to install it. The official name of the package is MySQL-workbench. All we need to do to install it is run the following command:
$ sudo apt-get install mysql-workbench
We need to go to the main menu and click on the MySQL workbench launcher icon to launch the program. The main page will appear after starting the program.
We have only scratched the surface of the various functions of the MySQL workbench utility in this article, because it would be difficult to list them all here.