Install and configure phpmyadmin in linux – ubuntu.

If you are a programmer then the first thing that you do to your fresh Linux/Ubuntu desktop is install apache, php and mysql server. Then comes the part where you install phpmyadmin to manage the mysql server.

The installation and configuration of phpmyadmin is not straight forward as that of the previous apache, php or mysql.

Then lets get straight to it.

Firstly insure that you have installed the module to attach php to the apache server.

$ sudo apt-get install libapache2-mod-php

This will set up the necessary connections between the php and apache server.

Now you apache server can run the php scripts.

So lets install the phpmyadmin

$ audo apt-get install phpmyadmin

This will present you with screens to set up the mysql password for the user root. So just provide the password and continue with the installation.

After the package has been installed, we configure apache with the phpmyadmin in /etc/apache2/apache2.conf file. Append the following to the last of the file

#Include phpmyadmin:
Include /etc/phpmyadmin/apache.conf

This alone may configure the phpmyadmin with the apache server. Then restart the apache server to get started.

Exceptions:

Sometimes only appending the above lines to the apache2.conf may not be enough. And running http://localhost/phpmyadmin may return a blank screen.

In such case, we need to add a additional module to the php.

$ sudo apt-get install php-gettext

and finally restart the apache server and run the phpmyadmin again. This time the humble phpmyadmin should load up.

Well in my case it did. So try it for your self.