This post shows students and new users the steps to install and use MySQL Workbench on Ubuntu Linux. MySQL Workbench is software that can be used to manage MySQL databases from a local or remote machine.
It supports database and user management, creating and executing SQL queries, configuring servers, performing backups, performing migrations, and much more. Whether you are a new user or a professional, MySQL Workbench makes it easy to manage your MySQL database.
Workbench will also work with MariaDB databases as MariaDB is a direct replacement for MySQL. You should be able to install Workbench and use it on other Linux distributions, not just Ubuntu Linunx.
Also, for students and new users learning Linux, the easiest place to start learning is Ubuntu Linux. Ubuntu is the modern open source Linux operating system for desktops, servers, and other devices.
Ubuntu is a great Linux operating system for beginners.
To start installing MySQL Workbench on Ubuntu Linux, follow the steps below.
How to install MySQL Workbench from Snap
Installing MySQL Workbench on Ubuntu is a fairly straightforward process. Workbench package cannot be found in Ubuntu repository as of Ubuntu 20.04.
You can use Snap package management to install the community version. Just run the following commands to install the community version of MySQL Workbench from Snap.
sudo snap install mysql-workbench-community.
Once the Workbench is installed, you can start it from the command line by typing
mysql-workbench-community or by clicking the MySQL Workbench icon from Activities -> Overview -> MySQL Workbench.
To connect to a database server, click Database ==> Connect to database. You can also add a new connection by clicking the circled plus sign ⊕ next to «MySQL connections”.
Set up a new connection, enter the database server credentials, and test the connection. Once everything is entered correctly, it should be added and ready to go.
MySQL and MariaDB using root passwords
Both MariaDB and MySQL servers come with the root user configured to use the auth_socket default authentication method.
the auth_socket The plugin authenticates users connecting from the local host through the Unix socket file. This means that you cannot authenticate as root by providing a password.
However, you can disable the auth_socket plugin using the SQL commands below. If you do, you will be prompted to enter the root password to log in.
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'type_strong_password_here';
UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE User="root";
You should be able to log in with the root password.
In this tutorial we have seen how to install and use MySQL Workbench on Ubuntu Linux. If you find any errors above, please use the comment form below.