> For the complete documentation index, see [llms.txt](https://paul-gleason.gitbook.io/champlain-college-classes/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://paul-gleason.gitbook.io/champlain-college-classes/sys-360-cloud-admin/labs/lab-5-2-lamp-stack-in-aws-part-2.md).

# Lab 5-2: LAMP Stack in AWS Part 2

## Secure the database server: <a href="#secure-mariadb-lamp-server" id="secure-mariadb-lamp-server"></a>

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**

<figure><img src="/files/rxTTX9CAmMOfq1yM15TY" alt=""><figcaption></figcaption></figure>

## Install phpMyAdmin: <a href="#install-phpmyadmin-lamp-server" id="install-phpmyadmin-lamp-server"></a>

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.](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
```

**SUBMIT: Screenshot showing successful PHP MyAdmin Login**

<figure><img src="/files/CaCZGX9W5gm2lg3AxHy6" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/zQpRU94ogJo9DdcBQQbx" alt=""><figcaption></figcaption></figure>