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:

http://mixeduperic.com/ubuntu/how-to-install-lamp-on-ubuntu-linux-apache-mysql-and-php-in-one-command.html

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:

http://mixeduperic.com/ubuntu/how-set-static-ip-address-ubuntu-server.html

Type the following to find your IP address

ifconfig

 

 

ifconfig - used to find the servers 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.

 

 

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.

http://YourServerIPaddress/phpmyadmin

 

 

http://IPAddress/phpmyadmin

 

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:

http://mixeduperic.com/ubuntu/how-to-restrict-phpmyadmin-ip-address.html

 

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