Relational database management systems like MySQL are needed for a significant portion of web sites and applications. However, not all users feel comfortable administering their data from the command line. To solve this problem, a project called phpMyAdmin was created in order to offer an alternative in the form of a web-based management interface.

Prerequisites

I am assuming that you have a running Ubuntu 14.04 Server and Linux part have taken care of as well. The steps in this post require the user to have root privileges. If you do not have any root privilege then you can ask for it to your server administrator.

You must have installed LEMP (Linux, Nginx, MySQL, and PHP) stack on your Ubuntu 14.04 server. If you don't have LEMP installed, you can have it easily following my previous post Setup and configure LEMP stack in Ubuntu 14.04

Installing phpMyAdmin

It is just a piece of cake. Run the following command in your terminal

sudo apt-get install phpmyadmin  


That's all!!
During the installation, phpmyadmin will ask you if you want to configure the database with dbconfig. Go ahead and choose yes.

Input MySQL’s database root password when prompted and click ok.

When phpmyadmin prompts you to choose a server (either apacheor lighttpd) hit tab, and select neither one.

Configure phpMyAdmin

Now you have phpMyAdmin installed on your server but you cant access it as you did not configure it yet. To access phpMyAdmin using Nginx you need to create a symbolic link between phpMyAdmin and your site’s document root directory.

sudo ln -s /usr/share/phpmyadmin/ /path/to/your/document/root  

Restart Nginx

sudo service nginx restart  

You should now be able to access phpMyAdmin by going to http://yourdomain-or-ip/phpmyadmin

If you face any problem.. just give me a shout to blow my eardrums!!!. Good Luck!!!

© 2016. All Rights Reserved.

Proudly published with Ghost