Table of Contents

1. Challenge

   Install the mariadb and mariadb-server Software Packages

   Use YUM to install mariadb-server and mariadb packages:

   sudo yum -y install mariadb-server mariadb
   

2. Challenge

   Ensure That the mariadb.service Starts and Is Enabled to Start at Boot Time

   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
   

3. Challenge

   Secure the mariadb database server by Setting the root Password, Removing Anonymous Users, Not Allow Remote Root Logins, Removing the Test Databases, and Reload Privileges

   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
   

4. Challenge

   Create the Database people and the User dbadmin, Then Grant 'dbadmin'@'localhost' Full Access to the people Database

   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
   

5. Challenge

   Verify the dbadmin User has Full Access to the people Database

   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