Lab 5.2: LAMP Stack in AWS Part 2

Secure the database server:

Start the MariaDB server.

sudo systemctl start mariadb

Run mysql_secure_installation.

sudo mysql_secure_installation

1. When prompted, type a password for the root account.
   • Type the current root password. By default, the root account does not have a password set. Press Enter.
   • Type Y to set a password, and type a secure password twice. . Make sure to store this password in a safe place.
2. Type Y to remove the anonymous user accounts.
3. Type Y to disable the remote root login.
4. Type Y to remove the test database.
5. Type Y to reload the privilege tables and save your changes.

Set the MariaDB server to start at every boot, type the following command.

sudo systemctl enable mariadb

Submit: Screenshot showing the mariadb status as active

Install phpMyAdmin:

Install the required dependencies.

sudo yum install php-mbstring -y

Restart Apache.

sudo systemctl restart httpd

Restart php-fpm.

sudo systemctl restart php-fpm

Navigate to the Apache document root at /var/www/html.

cd /var/www/html

Select a source package for the latest phpMyAdmin release from https://www.phpmyadmin.net/downloads Links to an external site.. To download the file directly to your instance, copy the link and paste it into a wget command, as in this example:

wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.tar.gz

Create a phpMyAdmin folder and extract the package into it with the following command.

mkdir phpMyAdmin && tar -xvzf phpMyAdmin-latest-all-languages.tar.gz -C phpMyAdmin --strip-components 1

Delete the phpMyAdmin-latest-all-languages.tar.gz tarball.

rm phpMyAdmin-latest-all-languages.tar.gz

SUBMIT: Screenshot showing successful PHP MyAdmin Login