Install MySQL Workbench on Ubuntu 20.04—Linux Hint

MySQL Workbench is a graphical person interface instrument used for the MySQL database administration. Primarily, this instrument is utilized by database architects, directors, and database builders to visualise the design of the database.MySQL Workbench offers varied options by which visible SQL growth, connection administration, database migration, visible DB administration, and information modelling are included. It’s a cross-platform software program that may be put in on varied working environments similar to Linux, Home windows, and Mac OS. MySQL Workbench has three completely different editions, neighborhood, normal, and enterprise. The neighborhood version is open-source. Due to this fact, it may be used for private use.

On this article, we are going to talk about how one can set up MySQL workbench on Ubuntu20.04 utilizing the command line. Let’s begin!

Set up of MySQL Workbench on Ubuntu 20.04

You’ll be able to set up MySQL workbench utilizing the next two methods:

  1. Utilizing the apt repository
  2. Set up MySQL workbench utilizing Deb packages

Utilizing the apt repository

You might want to carry out the below-mentioned steps to put in MySQL workbench in your Ubuntu system.

Step 1: Obtain configuration file from the apt repository

Utilizing this technique, you may set up MySQL from the official apt repository. For this objective, obtain the repository configuration file from the given URL https://dev.mysql.com/downloads/repo/apt/. If you browse this URL, it should take you instantly on the obtain web page from the place you’ll obtain ‘mysql-apt-config_0.8.15-1_all.deb’ repo configuration file. Click on on the Obtain possibility.

On the subsequent web page, it should ask you both you wish to register or log in. In case you don’t wish to choose these choices then, click on ‘No thanks, simply begin my obtain’ hyperlink to obtain the required package deal to your system’s native listing.

The next dialogue field will seem on the system. Select the Save File possibility and choose the situation the place you wish to save the obtain. In any other case, by default, it will likely be saved into your system Downloads.

Verify the downloaded configuration file within the specific listing. To do this, navigate into the Downloads utilizing the next command and record recordsdata.

Step 2: Configuration of MySQL apt config

Use the next command so as to add MySQL repository URLs within the apt sources record in an effort to set up the software program in your Ubuntu 20.04 system.

$ sudo apt set up ./mysql-apt-config_0.8.15-1_all.deb

Through the set up, you can be requested to decide on the model of MySQL. Right here, it’s preselected. Due to this fact, choose OK by navigating the down arrow key after which hit ‘Enter’ out of your keyboard.

After that, it should additional full the set up course of.

Step 3: Replace apt-cache

Replace the apt cache utilizing the next command to replace the configuration URLs.

Step 4: Putting in MySQL Workbench on Ubuntu 20.04

Now, it’s time to put in MySQL workbench utilizing the apt repository. To do this, execute the next command to put in MySQL workbench.

$ sudo apt set up mysql-workbench-community

Step 5: Launch MySQL Workbench

As soon as the set up is full, you’ll lastly launch the MySQL Workbench in your system. You’ll be able to launch it utilizing the terminal by typing the next command:

You may also launch MySQL Workbench from the applying launcher as follows:

Click on on the airing MySQL workbench icon. You will note the next interface in your Ubuntu system.

Set up MySQL workbench utilizing Deb packages

You may also obtain the MySQL workbench instantly from SQL official web site. Then, you may set up it with the assistance of the next technique:

Step 1:

Obtain the MySQL workbench utilizing the next URL https://dev.mysql.com/downloads/workbench/. Now, you’ll select the next choices manually.

1. Select ‘Ubuntu Linux’ working system.

2. Select the working system model; right here, we’re deciding on ‘Ubuntu Linux 20.04 (x86, 64-bit)’ in line with our system specs.

3. Click on on ‘Obtain’

4. On the subsequent window, you’ll choose ‘No thanks, simply begin my obtain‘ to obtain the deb packages into your native listing.

Step 2:

As soon as the obtain is accomplished, now navigate into ‘Downloads’ and problem the next command to put in the deb packages with all its dependencies.

$ sudo apt set up ./mysql-workbench-community_8.0.20-1ubuntu20.04_amd64.deb

Step 3: Launch the MySQL workbench in your Ubuntu system.

That’s all concerning the set up of MySQL workbench on Ubuntu 20.04.

Uninstall MySQL Workbench

In case you don’t wish to use this instrument additional, then you may take away MySQL workbench out of your Ubuntu system utilizing the next command.

$ sudo apt take away mysql-workbench-community

Conclusion

On this article, you will have realized how one can set up MySQL workbench on Ubuntu 20.04 system utilizing the terminal instructions. Furthermore, you will have realized how one can add an apt configuration file into the supply record. Additional, you may discover using MySQL workbench and SQL instructions. I hope this text will aid you sooner or later.

unable to locate package mysql-workbench,install mysql workbench centos 7,mysql-workbench debian 10,how to install mysql in ubuntu,e: package 'mysql-workbench' has no installation candidate,mysql gui for ubuntu,ubuntu server 20.04 mysql,ubuntu 20.04 mysql 8

You May Also Like