How to install MySQL on CentOS 8

By the previous articles, you know MySQL is an open-source database management system. In this article, you are going to learn how to install MySQL on CentOS 8. Which is installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack

How to install MySQL on CentOS 8

1- Installing MySQL

You can access to MySQL version 8 on CentOS 8 from the default repositories.

To install the mysql-server package and a number of its dependencies run the command below.

sudo dnf install mysql-server

When you are asked to proceed, press y and then ENTER.

. . .  Install  49 Packages    Total download size: 46 M  Installed size: 252 M  Is this ok [y/N]: y

While the MySQL you have installed till here, is not operational you need to start it with systemctl command.

sudo systemctl start mysqld.service

It’s time to check is the service running correctly or not. So enter the following command.

sudo systemctl status mysqld  

In case of successful starting, you would see below for an active MySQL service.

● mysqld.service - MySQL 8.0 database server     Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)     Active: active (running) since Thu 2020-03-12 14:07:41 UTC; 1min 7s ago   Main PID: 15723 (mysqld)     Status: "Server is operational"      Tasks: 38 (limit: 5056)     Memory: 474.2M     CGroup: /system.slice/mysqld.service             └─15723 /usr/libexec/mysqld --basedir=/usr    Mar 12 14:07:32 cent-mysql-3 systemd[1]: Starting MySQL 8.0 database server...  Mar 12 14:07:32 cent-mysql-3 mysql-prepare-db-dir[15639]: Initializing MySQL database  Mar 12 14:07:41 cent-mysql-3 systemd[1]: Started MySQL 8.0 database server.

You can set MySQL to start whenever the server boots up with command below.

sudo systemctl enable mysqld

Note: If you want to disable MySQL from starting up at boot, use the following command.

sudo systemctl disable mysqld

Now MySQL is installed now.

Buy Linux Virtual Private Server

2- Securing MySQL

The MySQL includes a security script, to use the security script, run the following command.

sudo mysql_secure_installation  

whether you are asked to set up the Validate Password Plugin and you prefer to do that, the script will ask you to choose a password validation level.

Output

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    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: 2

Then enter and then confirm a secure password.

Output

Please set the password for root here.      New password:     Re-enter new password:

So if you are satisfied with the password you choose from point of strength and security,  enter Y to continue the script:

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

3- Testing MySQL

If you want to verify the installation by connecting with the mysqladmin tool, use the command below to connect to MySQL as root.

mysqladmin -u root -p version

The output would be as below:

mysqladmin  Ver 8.0.17 for Linux on x86_64 (Source distribution)  Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.    Oracle is a registered trademark of Oracle Corporation and/or its  affiliates. Other names may be trademarks of their respective  owners.    Server version      8.0.17  Protocol version    10  Connection      Localhost via UNIX socket  UNIX socket     /var/lib/mysql/mysql.sock  Uptime:         2 hours 52 min 37 sec    Threads: 2  Questions: 20  Slow queries: 0  Opens: 131  Flush tables: 3  Open tables: 48  Queries per second avg: 0.001

If you want to add data after connecting to MySQL, run the following command:

mysql -u root -p

Then, you will see the MySQL prompt, when you enter your root MySQL user’s password.

mysql>

From now on, you can begin your MySQL installation and create and load databases.

Dear user, we hope you would enjoy this tutorial, you can ask questions about this training in the comments section, or to solve other problems in the field of Eldernode training, refer to the Ask page section and raise your problems in it.

Do not miss

Tutorial set up SSH Keys on CentOS 8