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.

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

Step-4:- Restart your apache server.

sudo service apache2 restart

Now finally run your phpmyadmin tool on browser.

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


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