Ubuntu

How to Install MySQL on Ubuntu 22.04

In the modern big data ecosystem, MySQL is one of the most well-known technologies. It is also referred to as a popular and effective database across many industries. To master this database management system, only a basic understanding is required. Even if you are unfamiliar with relational systems, you can create secure, fast, and powerful storage systems with MySQL.

This write-up will discuss the procedure to install MySQL on Ubuntu 22.04. So, let’s start!

How to install MySQL on Ubuntu 22.04

To install MySQL on Ubuntu 22.04, you must follow the below-given step-by-step instructions.

Step 1: Update system repositories

Press “CTRL+ALT+T” to open the terminal of the Ubuntu 22.04 and run the below-given command to update system repositories:

$ sudo apt update

Step 2: Install MySQL on Ubuntu 22.04

In the next step, install the MySQL on your system with the help of the following command:

$ sudo apt-get install mysql-server

Wait for a few minutes as the installation of the MySQL will take some time to complete:

Step 3: Verify MySQL service status

Then, check the status of the “mysql” service:

$ systemctl is-active mysql

The given output signifies that “mysql” service is currently active and running on our Ubuntu 22.04 system:

Step 4: Configure MySQL server

Now, write out the below-given command for performing an initial and interactive configuration of the MySQL server:

$ sudo mysql_secure_installation

In the configuration manual, you will be first asked to set the level for the password validation policy. Input a number from the given menu according to your password validation requirements:

After doing so, type out the new password for “root” and enter “y” to continue with the provided password:

Also, set the other configuration options accordingly:

Step 5: Log in to MySQL server

Next, log in to the MySQL server for setting the default authentication method to “mysql_native_password” and specify a native password for the root:

$ sudo mysql

As you can see, the following query will set the root password to “Password123#@!” and the authentication method to “mysql_native_password”:

> ALTER USER 'root'@'localhost'

IDENTIFIED WITH mysql_native_password BY 'Password123#@!';

Reload the grant tables in the MySQL database so that the changes can be applied without restarting the “mysql” service:

> FLUSH PRIVILEGES;

Again, try to login into the MySQL with the password you have set previously:

The above-given error-free output signifies that we have successfully installed and configured MySQL on our Ubuntu 22.04 system.

Lastly, to assure that the MySQL service is active, execute the following command:

$ systemctl status mysql.service

We have compiled the method to install MySQL on Ubuntu 22.04. Give it a try and work on this fantastic database management system.

Conclusion

To install MySQL on Ubuntu 22.04, first, execute the system repositories and then execute the “sudo apt-get install mysql-server” command. After that, configure it on your system using the “sudo mysql_secure_installation” command. Using the configuration manual, you can set the level of the password validation policy, remove the test database and its access, and reload the privileges. This write-up discussed the method to install MySQL on Ubuntu 22.04.

About the author

Sharqa Hameed

I am a Linux enthusiast, I love to read Every Linux blog on the internet. I hold masters degree in computer science and am passionate about learning and teaching.