Install PhpMyAdmin – Ubuntu 14.04 – Lamp

In this tutorial I will show you how to setup PhpMyAdmin. As always my platform is a LAMP stack running on a headless Ubuntu 14.04 LTS server edition.

PhpMyAdmin is a great tool to manage your Mysql database with a simple but powerful web interface. You can create users and database tables and delete them as well, so you don’t have to use the terminal for creating new databases and db users.

 

Step 1. Install PhpMyAdmin

We are going to download the package list from our repositories and install PhpMyAdmin

  • The installer will ask you which platform you are using. You should choose Apache if that is your platform, otherwise Nginx.
  • Select yes to dbconfig-common
  • You will be prompted for your database password (that is your Mysql password)
  • You will then be asked to set a new password for PhpMyAdmin root user

PhpMyadmin need the mcrypt module to be enabled, so to enable the module you should run this command in the terminal.

after the mcrypt module is enabled you need to restart your Apache server

Step 2. Access PhpMyAdmin

By now everything should be installed and up and running. Open your browser and type https://you_ip_address_or_domain/phpmyadmin
The site you are entering should look like this

Selection_014

You can login with:

  • Username : root
  • Password : The one you created in the installation

If you have access to the server outside of a local network I will strongly recommend that you secure your PhpMyAdmin instance. You can see how you can secure your PhpMyAdmin application here.