phpmyadmin is a web interface to your MySQL databases. It makes managing, creating and configuring your MySQL database a breeze. It is a very common tool and is often installed by default by many web host. In this article we will cover on how to install PHPMYSQL on Ubuntu Server 10.04 (LTS). You will need to already have the LAMP stack installed for these steps to work. If you need help on how to install LAMP (Linux, Apache, MySQL, and PHP) please visit the following article:
For security reasons I recommend restricting access to phpmyadmin from a specific internal IP address.
sudo apt-get install phpmyadmin
Enter Your password
Select apache by hitting the space bar when apache is highlighted.
Select Yes to configure phpmyadmin database.
Enter MySQL password
Create phpmyadmin db password or you can leave it blank to have one created for you. I have always created one myself.
If you decided to create a phpmyadmin database password enter it again.
We will need to know the IP address of the machine you just installed phpmyadmin on. Once we know this we can access the tools from a web browser on a computer on your network. It is a good idea to set a static IP address on your server so it will not change. If you need some help on how to do this on an Ubuntu server take a look at the following article:
Type the following to find your IP address
You can see one device has an IP address of 127.0.0.1. We can ignore this address because this is a loopback address. I can see that my IP address for device eth0 is 192.168.1.114.
So now that we know the IP address of the machine with phpmyadmin installed. Let’s navigate to the phpmyadmin login page.
User name will be root
Password will be the root password when you installed MySQL.