Installation of PHPMyAdmin on your Ubuntu VPS
This article covers the basics of setting of PHPMyAdmin to manage your MySQL databases on your Ubuntu Linux machine. These instructions will also work for a variety of other linux distributions as well. This is part of our series on setting up a Linode VPS with a fully working PHP, Apache, MySQL setup with multiple domains.
The following articles may be of interest to you:
Basic Linode VPS Setup
PHP, Apache, MySQL Setup on Ubuntu
Drupal Setup on Ubuntu
1. PhpMyAdmin Setup
sudo aptitude install phpmyadmin
This sets up phpmyadmin at your default server /phpmyadmin
PhpMyAdmin uses the following components/locations by default:
/usr/share/phpmyadmin
/etc/apache2/conf.d/phpmyadmin.conf
/etc/phpmyadmin
Below is a minor security change to the location of phpmyadmin to offset hackers who try to break in via the interface by going to yoursite.com/phpmyadmin . This isn’t all that strong, but every little thing helps.
2. Minor PhpMyAdmin Security Change
sudo nano /etc/apache2/conf.d/phpmyadmin.conf
Change Alias /myphpalias to /usr/share/phpmyadmin
Then available at http://domainname/myphpalias instead of phpmyadmin