In this step we are going to add phpMyAdmin. This software is a GUI for our browser that enables us to manage our mySQL databases. We are able to setup users, passwords, permissions, manage databases and most everything else you can do from the command line for mysql. Let's get started.

Enter the command:

sudo apt-get install phpmyadmin

You will be asked to some questions during the setup

1. Select Apache as your server

2. Choose Yes to configure the database for phpMyAdmin

3. Enter your mySQL password

4. Make a password and confirm for phpMyAdmin

Next we need to add the phpMyAdmin configurations to the configuration file in Apache.

Enter the command:

sudo nano /etc/apache2/apache2.conf

At the bottom of the file add the following line

Include /etc/phpmyadmin/apache2.conf

Ctrl X, y and enter

Restart Apache with the following command:

sudo service apache2 restart

Now you want to enter youripaddress/phpmyadmin in the address bar of your browser. The phpMyAdmin page should come up in your browser. Enter your mySQL password and it will load up GUI for your mySQL databases.