Securing the MariaDB Database Server

Use YUM to install mariadb-server and mariadb packages:

sudo yum -y install mariadb-server mariadb

Use the systemctl command to enable and start the mariadb.service, then check on its status:

sudo systemctl enable mariadb.service --now
sudo systemctl status mariadb.service

Use the mysql_secure_installation to set the the database server's root password to L12i3n4u5Xrocks. Then follow the prompts to remove anonymous users, disallow remote root logins, remove the test database, and reload the privilege tables immediately:

sudo mysql_secure_installation

Use the command line database client command mysql to connect to the database as the root user with the password L12i3n4u5Xrocks. Create a database named people, a 'dbadmin'@'localhost' user identified by the password SeQuel2001. Then, grant all rights to the people database to the new user.

mysql -u root -p  # Enter the password when prompted: L12i3n4u5Xrocks
create database people;
create user 'dbadmin'@'localhost' identified by 'SeQeuL2001';
grant all on people.* to 'dbadmin'@'localhost';
quit

Use mysql to log in as the user dbadmin, and provide the SeQeuL2001 password. Use the people database, create and drop a minimal test table, to verify administrative privileges and exit:

mysql -u dbadmin -p
use people;
create table test (id text);
drop table test;
exit