How to Install MySQL 8.0 on Rocky Linux 8

MySQL is a free, open-source, and extremely popular relational database management system. It is a simple, fast, and scalable SQL-based database system that can be installed as part of a LAMP or LEMP stack. Due to its speed and efficiency, it is the best choice for e-commerce and data warehousing applications. MySQL is readily available for all Linux distributions as well as other operating systems.

In this post, we will explain how to install MySQL 8 on Rocky Linux 8.

Install MySQL 8.0 on Rocky Linux 8

By default, MySQL 8.0 is included in the Rocky Linux AppStream repository. You can verify the available MySQL versions with the following command:

dnf module list mysql

You will get the following output:

Rocky Linux 8 - AppStream -13 MB/s | 9.7 MB     00:00    
Rocky Linux 8 - BaseOS -6.4 MB/s | 6.8 MB     00:01    
Rocky Linux 8 - Extras - 22 kB/s |  12 kB     00:00    
Rocky Linux 8 - AppStream - mysql- 8.0 [d]- client, server [d]- MySQL Module                        

Next, enable the MySQL repository with the following command:

dnf module enable mysql:8.0

You will get the following output:

Last metadata expiration check: 0:00:15 ago on Tuesday 05 April 2022 03:20:47 PM UTC.
Dependencies resolved.
==============================================================================================================================================
 Package                           Architecture                     Version                           Repository                         Size
==============================================================================================================================================
Enabling module streams:
 mysql                                                              8.0                                                                      

Transaction Summary
==============================================================================================================================================

Is this ok [y/N]: y

Now, install MySQL 8.0 by running the following command:

dnf install @mysql -y

Once the MySQL is installed, you can verify the installed version of MySQL using the following command:

mysql --version

You will get the following output:

mysql  Ver 8.0.26 for Linux on x86_64 (Source distribution)

Also Read

How to Delete or Remove Databases in MySQL

Manage MySQL 8.0 Service

By default, the MySQL service is managed by systemd. You can use the systemctl command to manage it from the command line.

To start the MySQL service, run the following command:

systemctl start mysqld

Enable the MySQL service to start at system reboot with the following command:

systemctl enable mysqld

To check the status of the MySQL service, run the following command:

systemctl status mysqld

You will get the following output:

● mysqld.service - MySQL 8.0 database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
   Active: active (running) since Tue 2022-04-05 15:42:24 UTC; 13s ago
  Process: 26108 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SUCCESS)
  Process: 25984 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mysqld.service (code=exited, status=0/SUCCESS)
  Process: 25960 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
 Main PID: 26064 (mysqld)
   Status: "Server is operational"
    Tasks: 38 (limit: 11412)
   Memory: 464.0M
   CGroup: /system.slice/mysqld.service
           └─26064 /usr/libexec/mysqld --basedir=/usr

Apr 05 15:42:16 rockylinux systemd[1]: Starting MySQL 8.0 database server...
Apr 05 15:42:16 rockylinux mysql-prepare-db-dir[25984]: Initializing MySQL database
Apr 05 15:42:24 rockylinux systemd[1]: Started MySQL 8.0 database server.

Secure MySQL Installation

By default, MySQL is not secured and the root password is not set. You can secure it by running the following command:

mysql_secure_installation

You will be asked to set up the VALIDATE PASSWORD component:

Securing the MySQL server deployment.

Connecting to MySQL using a blank password.

VALIDATE PASSWORD COMPONENT can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD component?

Press y|Y for Yes, any other key for No: y

Type Y and press the Enter key. You will be asked to choose the level of password validation policy:

There are three levels of password validation policy:

LOW    Length >= 8
MEDIUM Length >= 8, numeric, mixed case, and special characters
STRONG Length >= 8, numeric, mixed case, special characters and dictionary                  file

Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 1

Type your preferred option and press the Enter key. You will be asked to set a root password:

Please set the password for root here.

New password: 

Re-enter new password: 

Set your root password and press the Enter key. You will be asked to continue with the provided password:

Estimated strength of the password: 100 
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : Y

Type Y and press the Enter key. You will be asked to remove anonymous users:

Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y

Type Y and press the Enter key. You will be asked to remove the test database:

Remove test database and access to it? (Press y|Y for Yes, any other key for No) : Y

Type Y and press the Enter key. You will be asked to reload the privilege tables:

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y

Type Y and press the Enter key to finish the process.

Also Read

How to Allow Remote Connection to MySQL Database Server

Connect to the MySQL Server

After securing the MySQL, you can connect to the MySQL shell using the following command:

mysql -u root -p

You will be asked to provide your root password:

Enter password: 

Provide your root password and press the Enter key. Once you are logged in, you should see the MySQL shell in the following output:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.26 Source distribution

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

You can check the MySQL version with the following command:

mysql> SELECT VERSION ();

You will get the following output:

+------------+
| VERSION () |
+------------+
| 8.0.26     |
+------------+

Create a Database and User in MySQL

To create a database named testdb, run the following command:

mysql> CREATE DATABASE testdb;

To create a user named testuser, run the following command:

mysql> CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'securepassword';

To grant all the privileges to the testdb database, run the following command:

mysql> GRANT ALL ON testdb.* TO 'testuser'@'localhost';

Now, flush the privileges to apply the changes:

mysql> FLUSH PRIVILEGES;

To list all MySQL users, run the following command:

mysql> select user from mysql.user;

You will get the following output:

+------------------+
| user             |
+------------------+
| mysql.infoschema |
| mysql.session    |
| mysql.sys        |
| root             |
| testuser         |
+------------------+

To list all databases, run the following command:

mysql> SHOW DATABASES;

You should see the following output:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| testdb             |
+--------------------+

Now, exit from MySQL using the following command:

mysql> EXIT;

Remove or Uninstall MySQL 8

If you don’t need to use MySQL and want to remove it from your system, run the following command:

dnf remove @mysql

After removing MySQL, remove the MySQL data directory with the following command:

rm -rf /var/lib/mysql*

Conclusion

In the above post, we showed you how to install MySQL 8.0 on Rocky Linux 8. We also explained how to create a database and user in MySQL. Try it on a dedicated server from Atlantic.Net!