How to Install MySQL Workbench on Ubuntu Linux

office 4551450 640

This post shows students and new users steps to install and use MySQL Workbench on Ubuntu Linux. MySQL Workbench is a software that can be used to manage MySQL databases from a local or remote machine.

It supports managing databases and users, creating and running SQL queries, configuring servers, taking backups, performing migrations and much more. Whether you’re new user or a professional, MySQL Workbench makes managing MySQL database easy.

Workbench will also work with MariaDB databases since MariaDB is a drop-in replacement for MySQL. You should able be able to install Workbench and use on other Linux distributions, not just Ubuntu Linunx.

Also, for students and new users learning Linux, the easiest place to start learning is on Ubuntu Linux. Ubuntu is the modern, open source Linux operating system for desktop, servers and other devices.

Ubuntu is a great Linux operating system for beginners.

To get started with installing MySQL Workbench on Ubuntu Linux, follow the steps below.

How to install MySQL Workbench from Snap

Installing MySQL Workbench on Ubuntu is a pretty straightforward process. Workbench package can’t be found in Ubuntu repository starting with Ubuntu 20.04.

You can use Snap package management to install the community version. Simply run the commands below to install the MySQL Workbench community version from Snap.

sudo snap install mysql-workbench-community

Once Workbench is installed, you can start it either from the command line by typing mysql-workbench-community or by clicking on the MySQL Workbench icon from Activities -> Overview -> MySQL Workbench.

ubuntu install mysql workbench on ubuntu

To connect to a database server, click Database ==> Connect to Database. You can also add new connection by clicking on the circled plus sign ⊕ next to “MySQL Connections”.

Setup a new connection, type in the database server credentials and test the connection. Once everything is entered correctly, it should be added and ready to use.

MySQL and MariaDB using root passwords

Both MariaDB and MySQL servers come with the root user is set to use the auth_socket authentication method by default.

The auth_socket plugin authenticates users that connect from the localhost through the Unix socket file. This means that you can’t authenticate as a root by providing a password.

However, you can disable auth_socket plugin using the SQL commands below. If you do, then you’ll be required to type the root password to logon.

MySQL:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'type_strong_password_here';

MariaDB:

UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE User='root';

You should be able to login with root password.

Conclusion:

This post showed you how to install and use MySQL Workbench on Ubuntu Linux. If you find any error above, please use the comment form below.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.