How to Install and Configure phpMyAdmin on Debian 9/8

phpMyAdmin is an open source tool widely used for the MySQL database administration. It provides an easy to use graphical user interface. You can easily create, modify, delete database and tables. It also allows managing user and permission. You can also configure database replication using phpMyAdmin.

This tutorial helps you to install and configure phpMyAdmin on a Debian 9 (Stretch) or Debian 8 (Jessie) system.

Step 1 – Prerequsities

You must fulfill followings:

This tutorial is tested for installing phpMyAdmin on Debian 9/8. It may be also used on Ubuntu systems

You must have Debian system root user access or sudo privileged user to accomplish this task.

You must have preconfigured LAMP stack on your server. You can use our tutorial to Setup LAMP on Debian 9 or Setup LAMP on Debian 8

Step 2 – Install phpMyAdmin on Debian

First, update the Apt package manager cache on your Debian system to make the sure system have the latest version of packages.

sudo apt-get update

Now, Install phpMyAdmin by running the following command. This will also install required dependencies automatically.

sudo apt-get install phpmyadmin

The package configuration will ask for the basic configuration for phpMyAdmin. The first, you need to select web server to configure. This tutorial is using Apache web server.

For this option click ok.

Now select Yes for this option, let dbconfig-common create a database for phpMyAdmin.

Set a password for the newly created user and database for phpMyAdmin. You can keep this filed blank to auto-generate password.

Enter MySQL root user password required by the installer to create new user and database.

Step 3 – Configure Apache for phpMyAdmin

The phpMyAdmin setup is completed now. Just to make sure that phpmyadmin.conf is created under /etc/apache2/conf-enabled/ directory. Now you can access phpMyAdmin using system’s hostname or IP address.

This requires MySQL username and password to login to phpMyAdmin.