Installation instructions and security phpMyAdmin on Ubuntu 12:04

phpMyAdmin is an open source software popular on web platform to manage MySQL.

Before you proceed to install phpMyAdmin you need preinstalled LAMP or LEMP server on Ubuntu.

We have two ways to install phpMyAdmin is installed via phpMyAdmin package and run like a normal php script. 

The first one is simpler, while the latter two, the resource saving and more security.

1. Install phpMyAdmin package

Run the following command

sudo apt-get install phpmyadmin

During installation you should note that:

Select Apache2 server

Choose Yes when asked Configure the database for phpmyadmin with dbconfig-common

Add the MySQL password when asked

Add the password to access the phpMyAdmin

Once installed, additional phpmyadmin on the install configuration Apache

sudo nano /etc/apache2/apache2.conf

Add the following to the end

Include /etc/phpmyadmin/apache.conf

Restart apache

sudo service apache2 restart

Now you can access phpMyAdmin through the link http: //yourip/phpmyadmin.

2. Install phpMyAdmin script

This way better the first way. Because the two following reasons:

- Only when the new run using the memory -> server saves resources

- Customizable path phpmyadmin -> more security

First you need to choose the version you want to install the phpMyAdmin homepage.

Copy the link directly with file extension is .tar.gz , such as the version 4.1.4 is http://jaist.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/4.1.4/phpMyAdmin-4.1.4-all-languages.tar.gz

In www directory contains content sites, run the following command.

wget http://jaist.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/4.1.4/phpMyAdmin-4.1.4-all-languages.tar.gz

Extract

tar -xzvf phpMyAdmin-4.1.4-all-languages.tar.gz

Installation is complete you will have a folder phpMyAdmin-4.1.4-all-languages, to use your access to the link http: //ip/phpMyAdmin-4.1.4-all-languages. Of course you can rename anything you want to use and more secure.