Ubuntu Server Cookbook

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