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 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:

http://mixeduperic.com/linux/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

 

 

Enter Your password

 

Enter Your Password

 

 

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

 

Hight Light Apache2 and hit the spacebar

 

 

Select Yes to configure phpmyadmin database.

 

Select YES to configure phpmyadmin

 

 

Enter MySQL password

 

mysql administrator password

 

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

 

Leave Blank or Enter a password

 

 

 

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

 

Enter the Password one more time

 

 

 

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/linux/how-to-statically-set-your-ip-address-on-ubuntu-server.html

Type the following to find your IP address

ifconfig

 

ifconfig

 

 

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.

 

 

ifconfig find ip

 

 

 

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

 

url - phpmyadmin

 

 

 

phpmyadmin login page

 

 

 

User name will be root

Password will be the root password when you installed MySQL.

Advertisements

About lorddisk

WebCenter Content, WebCenter Portal, WebCenter Sites,Weblogic, Identity and Access Management (IAM),SSO,OAM,OIM,OAAM,OUD, OPAM,OID, OVD ,Oracle API Gateway ,OBIEE,OEDQ, Oracle ADF, Oracle SOA,J2EE, CackePHP ,PHP,J2SE,J2EE,Spring,Hibernate,JQuery,CSS,Java Script ,Joomla,Drupal,Worpress
This entry was posted in linux. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s