Deliverables

Screenshot showing the mariadb status as active

Screenshot showing successful PHP MyAdmin Login

Steps

Secure the database server

Start the MariaDB server

sudo systemctl start mariadb

Run mysql_secure_installation and follow the prompts

sudo mysql_secure_installation

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

sudo systemctl enable mariadb

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). 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

In a web browser, type the URL of your phpMyAdmin installation. This URL is the public DNS address followed by a forward slash and the name of your installation directory

http://ec2-3-83-145-101.compute-1.amazonaws.com/phpMyAdmin/