How to install MySQL 8 Database on CentOS 8

How to install MySQL 8 Database on CentOS 8

MySQL is the most commonly used and popular open-source RDBMS (Relational Database Management System) which is developed and incorporated by Oracle corporation. Most of the server scripts and websites use the MySQL database at the backend of their applications. MySQL database written in C/C++ and tested on various compilers. The latest MySQL version 8.0, that is available for installation in the default CentOS 8 dnf repository. However, we do not need to add any external repository on CentOS 8 for installing the MySQL database.

MySQL 8.0 launched with a bundle of new features that enhance the web application’s performance.  While working as a back-end developer or as a web developer, you must know all the features of SQL that you can easily learn using official MYSQL documentation. It is important to note that some applications are not compatible with most of the new MySQL features and changes. So, before installing any SQL version, you must consult the application documentation which you are deploying on CentOS 8 server.

In this article, we are going to explain how to install MySQL on CentOS 8 server using the command line environment.

Prerequisites

  • The CentOS 8 server is running properly on your system
  • Root or sudo privileges needed
  • Minimum 4GB RAM requirements

The command-line application ‘Terminal’ needed to run all commands. Therefore, launch the terminal from the left sidebar of your CentOS 8 desktop as follows:

How to install MySQL 8 Database on CentOS 8

Execute the following command on your system to log in as root:

$ su

Enter the account password. Now, you can run all administrative commands without using the sudo command.

How to install MySQL 8 Database on CentOS 8

Steps to Install MySQL 8.0 Database on CentOS 8

By implementing the following steps, you can easily install the MySQL database on your CentOS 8 system:

Step 1:
Update dnf repository

It is recommended or a best practice to update the system packages index before installing any new application. Therefore, use the following command to update the dnf CentOS 8 repository:

# sudo dnf update

The above command will automatically install the recommended packages updates on your system.

How to install MySQL 8 Database on CentOS 8

Step 2:
Install MySQL on CentOS 8

We have mentioned earlier, the MySQL database software is available for installation in the default dnf CentOS 8 repository. So, type the following command to install MySQL 8 using the dnf package manager:

# dnf install @mysql

How to install MySQL 8 Database on CentOS 8

Type ‘y’ and then press ‘Enter’ to proceed with the installation process. The above command will also install all supportive MySQL packages on your system.

Step 3:
Check installed MySQL version

To verify the MySQL installation, check the installed version by using the following command:

# mysql --version

How to install MySQL 8 Database on CentOS 8

Step 3:
Enable and start MySQL service

Without enabling the MySQL service, you can’t use the MySQL database. So, start and enable the ‘mysqld.service’ by using the following command:

# systemctl start mysqld.service
# systemctl enable mysqld.service

How to install MySQL 8 Database on CentOS 8

Once the mysqld.service is enabled. Check the running active status of the MySQL service by executing the following command:

# systemctl status mysql.service

The following ‘running and active’ status should display on the screen:

How to install MySQL 8 Database on CentOS 8

It is not mandatory to use ‘.service’ after every service. You can only run the following command by verifying the running status of the MySQL service:

# systemctl status mysqld

Step 4:
Configure mysql_secure_installation plugin

To make more secure MySQL configurations, MySQL comes with a security installation script. So, run this script on your system by running the following command:

# mysql_secure_installation

The following security configuration for the MySQL database will start on your system.

How to install MySQL 8 Database on CentOS 8

The validate password plugin checks the password strength. To set up the Validate password components, you need to confirm the number of prompts that will display on the terminal window.

Choose the password level.

How to install MySQL 8 Database on CentOS 8

Set the root user password for the MySQL database.

How to install MySQL 8 Database on CentOS 8

In the next prompt, you will remove the anonymous users.

How to install MySQL 8 Database on CentOS 8

Disallow the remote login configuration, remove test databases, and reload table privileges as follows:

How to install MySQL 8 Database on CentOS 8

Step 5:
Log in to MySQL database as Root

Once the Validate Password plugin is configured, you can now login as a root user to the MySQL database by running the following command:

# mysql -u root -p

Enter the password that you have recently set for the root user. After that, the following MySQL shell view displays on the terminal:

How to install MySQL 8 Database on CentOS 8

Create MySQL database

Create a new test_database by using the CREATE DATABASE command as follows:

mysql> CREATE DATABASE test_database;

How to install MySQL 8 Database on CentOS 8

List MySQL Databases

List all MySQL databases to verify that ‘test_database’ is created successfully.

mysql> SHOW DATABASES;

How to install MySQL 8 Database on CentOS 8

Create a new MySQL database user

Now, create a new MySQL database user by executing the below-mentioned command:

mysql> CREATE USER 'Samreena'@'localhost' IDENTIFIED BY 'Samreena_password';

How to install MySQL 8 Database on CentOS 8

We have created a new user named ‘Samreena’ and also assigned a password.

Exit from a MySQL shell

Type exit to close the MySQL shell environment as follows:

mysql> exit

The above command will close the MySQL command-line shell and move you back again to the normal shell.

How to install MySQL 8 Database on CentOS 8

Conclusion

This article contains profound information about the MySQL database installation. We provided the step-by-step installation of the MySQL database in this tutorial. You should have intermediate knowledge about the SQL command to run the MySQL database on your system. You can explore further the MySQL database and its available versions from the official MySQL website.

How To Set up a VSFTPD Server on a CentOS 7 VPS or Dedicated Server

Brief Description FTP is usually insecure exposing clear-text passwords, userna
2 min read
Avi Ilinsky
Avi Ilinsky
Hosting Expert

How To Set up a VSFTPD Server on an Ubuntu 16.04 VPS or Dedicated Server

Brief Description FTP data is usually insecure since information (usernames, pa
2 min read
Eliran Ouzan
Eliran Ouzan
Web Designer & Hosting Expert

How to use phpMyAdmin to develop a website (without MySQL experience)

Brief description A web developer who is not well versed into coding websites f
2 min read
Idan Cohen
Idan Cohen
Marketing Expert

How to Install MySQL on a Windows Web Server Running Apache

This tutorial will show you how to install the MySQL database on a Windows serve
3 min read
Michael Levanduski
Michael Levanduski
Expert Hosting Writer & Tester
HostAdvice.com provides professional web hosting reviews fully independent of any other entity. Our reviews are unbiased, honest, and apply the same evaluation standards to all those reviewed. While monetary compensation is received from a few of the companies listed on this site, compensation of services and products have no influence on the direction or conclusions of our reviews. Nor does the compensation influence our rankings for certain host companies. This compensation covers account purchasing costs, testing costs and royalties paid to reviewers.
Click to go to the top of the page
Go To Top