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:
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.