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.
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
It is just a piece of cake. Run the following command in your terminal
sudo apt-get install phpmyadmin
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
lighttpd) hit tab, and select neither one.
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
sudo service nginx restart
You should now be able to access
phpMyAdmin by going to
If you face any problem.. just give me a shout to blow my eardrums!!!. Good Luck!!!