Introduction to MySQL Workbench.
MySQL Workbench is a tool provided by the Oracle Corporation to manage its open-source MySQL database via a graphical user interface along with other collection of tools for working with MySQL databases. The software tool can be used to design and edit databases, to display them clearly and to administer them. For advanced users who need additional functions, extensions with scripting languages can be integrated into the tool.
MySQL Workbench is available in a community and a standard edition. The Community Edition is under a GPL license and is freely available. It can be used on computers with the operating systems Linux, macOS or Microsoft Windows.
Here in this tutorial, we will show the installation process of installing MySQL workbench on Ubuntu 20.04 using repository and command terminal.
- Ubuntu 20.04 LTS focal fossa with GUI
- A non-root user with
sudoaccess to execute the installation commands.
Step 1: Configure MySQL repository on Ubuntu 20.04
Although we can directly visit the Workbench official page to download its latest Debian packages, we also show that at the end of this article. However, those just want to go only via command terminal, they first need to add the MySQL APT repository. Here are the commands to do that.
First, download MySQL APT repository setup package
Go to this official page and click on “No thanks, just start my download” link given in the bottom. This will download the Debian packages of the repo.
Or use the below command, however, the version of the file was 0.8.15.1 while writing the tutorial and will change in future. So, it’s better to directly download from the above link.
Now, install and configure the downloaded repo package.
If you have downloaded it from the browser, then by default it will go to the Downloads folder, therefore, switch to that. However, those used the command to get the repo package they don’t need to change the directory.
sudo dpkg -i mysql-apt-config*.deb
The moment you run the above command, an interactive shell will open, use the TAB button and select the OK option, then just hit the ENTER button.
Step 2: Run system update command
To let the Ubuntu 20.04 know about the latest configured repository, run the update command so that it could flush the cache and rebuild it again.
sudo apt update
Step 3: Install MySQL Workbench on Ubuntu 20.04
The repo is configured and the Workbench presents in the tools repo. So, to install a community version of the Workbench run the following command. When it asks for your permission to install, just press Y key and hit the ENTER button.
sudo apt install mysql-workbench-community
The output for the above command:
h2smedia@dell-server:~$ sudo apt install mysql-workbench-community [sudo] password for h2smedia: Reading package lists... Done Building dependency tree Reading state information... Done The following additional packages will be installed: libpcrecpp0v5 libpython2.7 libpython2.7-minimal libpython2.7-stdlib libzip5 Suggested packages: libproj-dev The following NEW packages will be installed: libpcrecpp0v5 libpython2.7 libpython2.7-minimal libpython2.7-stdlib libzip5 mysql-workbench-community 0 upgraded, 6 newly installed, 0 to remove and 8 not upgraded. 2 not fully installed or removed. Need to get 26.4 MB of archives. After this operation, 141 MB of additional disk space will be used. Do you want to continue? [Y/n]
Step 4: Run Workbench from Activities
There are two ways to run Workbench, one is via the Activities and second, directly call it from Command terminal.
Click on Activities (on the top left side of the Ubuntu screen)->Find Workbench icon, click to run it.
If you want it open from the command line, simply type:
Second method: Install Workbench directly using Debian packages
If you don’t want to add the repository and all, then simply go to official Workbench download page using your system browser.
Select Ubuntu Linux from the OS drop-down box and click on the Download button.
Now, either double click on the downloaded Debian packages to install it with Ubuntu Software manager or open the command line and follow the below steps.
Switch to the Downloads directory
sudo dpkg -i mysql-workbench-community*.deb
In Future, if you want to uninstall the software then run:
sudo apt remove mysql-workbench-community
So, these were two quick to install Workbench database manager software on Ubuntu. Here are some other articles to see:
- Top MySQL GUI Tools for Windows and Ubuntu/Linux
- Setting up LAMP on Ubuntu 20.04 for beginner
- Install MySQL on Ubuntu 20.04 LTS Focal Fossa