Atlantic.Net Blog

How to Install MySQL 8.0 on Rocky Linux 8

Hitesh Jethva
by Atlantic.Net (395 posts) under Dedicated Server Hosting, Tutorials
0 Comments

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.

Prerequisites

  • A server running Rocky Linux 8 on the Atlantic.Net Cloud Platform
  • A root password configured on your server

Create Atlantic.Net Cloud Server

First, log in to your Atlantic.Net Cloud Server. Create a new server, choosing Rocky Linux 8 as an operating system with at least 1GB RAM. Connect to your Cloud Server via SSH and log in using the credentials highlighted at the top of the page.

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
Name                           Stream                          Profiles                                   Summary                             
mysql                          8.0 [d]                         client, server [d]                         MySQL Module                        

Hint: [d]efault, [e]nabled, [x]disabled, [i]nstalled

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)

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.

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 dedicated hosting from Atlantic.Net!

Get A Free To Use Cloud VPS

Free Tier Includes:
G3.2GB Cloud VPS Free to Use for One Year
50 GB of Block Storage Free to Use for One Year
50 GB of Snapshots Free to Use for One Year


Looking for a Hosting Solution?

We Provide Cloud, Dedicated, & Colocation.

  • Seven Global Data Center Locations.
  • Flexible Private, Public, & Hybrid Hosting.
  • 24x7x365 Security, Support, & Monitoring.
Contact Us Now! Med Tech Award FTC
SOC Audit HIPAA Audit HITECH Audit

Recent Posts

How to Install Apache Solr on Oracle Linux 8
How to Install Apache Cassandra on Oracle Linux 8
How to Install Yarn NPM Package Manager on Oracle Linux 8
How to Install Apache Spark on Oracle Linux 8
How to Install Docker and Docker Compose on Oracle Linux 8

Get started with 12 months of free cloud VPS hosting

Free Tier includes:
G3.2GB Cloud VPS Server Free to Use for One Year
50 GB of Block Storage Free to Use for One Year
50 GB of Snapshots Free to Use for One Year


New York, NY

100 Delawanna Ave, Suite 1

Clifton, NJ 07014

United States

San Francisco, CA

2820 Northwestern Pkwy,

Santa Clara, CA 95051

United States

Dallas, TX

2008 Lookout Dr,

Dallas, Texas 75044

United States

Ashburn, VA

1807 Michael Faraday Ct,

Reston, VA 20190

United States

Orlando, FL

440 W Kennedy Blvd, Suite 3

Orlando, FL 32810

United States

Toronto, Canada

20 Pullman Ct, Scarborough,

Ontario M1X 1E4

Canada

London, UK

14 Liverpool Road, Slough,

Berkshire SL1 4QZ

United Kingdom

Resources