Installing web access for MySQL

In this recipe, we will set up a well-known web-based MySQL administrative tool—phpMyAdmin.

Getting ready

You will need access to a root account or an account with sudo privileges.

You will need a web server set up to serve PHP contents.

How to do it…

Follow these steps to install web access for MySQL:

1. Enable the mcrypt extension for PHP:

   $ sudo php5enmod mcrypt
   

2. Install phpmyadmin with the following commands:

   $ sudo apt-get update
   $ sudo apt-get install phpmyadmin
   

3. The installation process will download the necessary packages and then prompt you to configure phpmyadmin:

   

4. Choose <yes> to proceed with the configuration process.

5. Enter the MySQL admin account password on the next screen:

   

6. Another screen will pop up; this time, you will be asked for the new password for the phpmyadmin user. Enter the new password and then confirm it on the next screen:

   

7. Next, phpmyadmin will ask for web server selection:

   

8. Once the installation completes, you can access phpMyAdmin at http...