Install and configure phpMyAdmin in ubuntu 14.04

Here you’ll learn installation and configuration of your favorite open source tool called phpMyAdmin.

What is phpMyAdmin?

phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.
—wikipedia

All php developer already know about this free tool, It by default inbuilt some windows/mac software called WAMP, XAMPP, MAMP etc.

But here i’ll show you how to configure phpMyAdmin in your ubuntu machine with LAMP Server.



I assume that you already have LAMP Stack installed in your ubuntu machine.

Step-1:- Run below command to install phpMyadmin in your machine.

sudo apt-get install phpmyadmin

At the time of installation it may ask for your database username and password.

Step-2:- Edit your apache configuration file.

sudo vim /etc/apache2/apache2.conf
OR
sudo nano /etc/apache2/apache2.conf

You can use any command line text editor to edit system file like nano or vim.

Step-3:- Now include the path of the phpMyadmin apache conf file.

Include /etc/phpmyadmin/apache.conf

See screen shot below..
phpmyadmin-1

Step-4:- Restart your apache server.

sudo service apache2 restart

Now finally run your phpmyadmin tool on browser.
http://localhost/phpmyadmin

And enter your mysql username and password to access mysql database details.

phpmyadmin-2

If you like this post please don’t forget to subscribe My Public Notebook for more useful stuff.