How to Install phpMyAdmin on Ubuntu 10.04 LTS Server

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 phpMyAdmin on Ubuntu Server 10.04 (LTS). You will need to already have the LAMP stack installed for these steps to work and have your MySQL root password handy. 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



sudo apt-get install phpmyadmin - Ubuntu





Enter Your password



Enter your password



Select apache by hitting the space bar when apache is highlighted.



Select your webserver - Default Apache



Select Yes to configure phpMyAdmin database.



Select Yes



Enter MySQL password



Enter Your MySQL root  password



Create phpMyAdmin db password or you can leave it blank to have one created for you. I have always created one myself.



Create a password for your MySQL database



If you decided to create a phpMyAdmin database password enter it again.



Confirm the password



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




ifconfig - used to find the servers IP address



You can see one device has an IP address of We can ignore this address because this is a loopback address. I can see that my IP address for device eth0 is



IP Address for eth0



So now that we know the IP address of the machine with phpmyadmin installed. Let's navigate to the phpMyAdmin login page.






Enter root for user and your MySQL root user password



User name will be root

Password will be the root password when you installed MySQL.


Landing Page of phpMyAdmin



For tips on how to restrict phpMyAdmin by IP address check out:


If you enjoyed this post, please share it on your favorite social network by clicking on the “Share / Save” bar below.