Home » Categories » Multiple Categories

How To Install phpMyAdmin on a LEMP server

About phpMyAdmin

phpMyAdmin is a free software to work with MySQL on the web—it provides a convenient visual front end to the capabilities of MySQL.

Setup

Prior to installing phpMyAdmin, be sure that you have LEMP installed on your server. If you do not, you can see how to do that here.
Once you have finished installing LEMP on your virtual private server, you can start on installing phpMyAdmin.

Step One—Install phpMyAdmin

Start off by downloading the program from apt-get.
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 password when prompted and click ok.
When phpmyadmin prompts you to choose a server (either apache or lighttpd) hit tab, and select neither one.

Step Two—Configure phpMyAdmin

You now have phpMyAdmin installed on your server. In order to access it, you need to take one more step.
Create a symbolic link between phpMyAdmin and your site’s directory. If you were using the previous tutorial, it may be still located in the nginx default directory, otherwise link it with the appropriate place:
sudo ln -s /usr/share/phpmyadmin/ /usr/share/nginx/www
Restart nginx:
sudo service nginx restart
You should now be able to access phpMyAdmin by going to yourdomain/phpmyadmin. The screen will look like this.
Log in with your MySQL username and password.
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
How to Get Started With mod_pagespeed with Apache on an Ubuntu and Debian Cloud Server
Viewed 1439 times since Thu, Dec 26, 2013
How To Install And Run A Node.js App On Centos 6.4 64bit
Viewed 4372 times since Sun, Dec 29, 2013
How To Install Linux, Nginx, MySQL, PHP (LEMP) Stack on Debian 7
Viewed 1931 times since Fri, Dec 27, 2013
How to Setup and Configure an OpenVPN Server on Debian 6
Viewed 1358 times since Thu, Dec 26, 2013
How To Install nginx on Ubuntu 12.04 LTS
Viewed 1670 times since Tue, Dec 24, 2013
How To Install an Upstream Version of Node.js on Ubuntu 12.04
Viewed 1511 times since Sun, Dec 29, 2013
How To Manage Content Using the Ghost Blogging Platform
Viewed 1599 times since Sun, Dec 29, 2013
How To Setup a Rails 4 App With Apache and Passenger on CentOS 6
Viewed 2082 times since Thu, Dec 19, 2013
How To Import and Export Databases and Reset a Root Password in MySQL
Viewed 1412 times since Thu, Dec 26, 2013
How To Set Up an NFS Mount on Ubuntu 12.04
Viewed 3980 times since Tue, Dec 24, 2013