How To Install and Secure phpMyAdmin on Ubuntu 12.04

https://www.digitalocean.com/community/articles/how-to-install-and-secure-phpmyadmin-on-ubuntu-12-04


Install phpMyAdmin

$ sudo apt-get install phpmyadmin

$ sudo nano /etc/apache2/apache2.conf
Include /etc/phpmyadmin/apache.conf

$ sudo service apache2 restart

youripaddress/phpmyadmin

Security

$ sudo nano /etc/phpmyadmin/apache.conf

<Directory /usr/share/phpmyadmin>
        Options FollowSymLinks
        DirectoryIndex index.php
        AllowOverride All
        [...]

Configure the .htaccess file

 $ sudo nano /usr/share/phpmyadmin/.htaccess

AuthType Basic
AuthName "Restricted Files"
AuthUserFile /path/to/passwords/.htpasswd
Require valid-user

Create the htpasswd file

$ sudo htpasswd -c /path/to/passwords/.htpasswd username


Finish up by restarting apache:

$ sudo service apache2 restart