Install and Secure phpMyAdmin on Ubuntu 16.04

phpMyAdmin was created so that users can interact with MySQL through a web interface. In this guide, we'll discuss how to install and secure phpMyAdmin so that you can safely use it to manage your databases from an Ubuntu 16.04 system.

Step One — Install phpMyAdmin

We can do this by updating our local package index and then using the apt packaging system to pull down the files and install them on our system:

• sudo apt-get update
• sudo apt-get install phpmyadmin php-mbstring php-gettext

Warning: When the first prompt appears, apache2 is highlighted, but not selected. If you do not hit Space to select Apache, the installer will not move the necessary files during installation. Hit Space, Tab, and then Enter to select Apache.

The installation process actually adds the phpMyAdmin Apache configuration file into the /etc/apache2/conf-enabled/ directory, where it is automatically read.

enable the PHP mcrypt and mbstring extensions, which we can do by typing:

sudo phpenmod mcrypt

sudo phpenmod mbstring

Restart Apache for your changes to be recognized:

sudo systemctl restart apache2

Access :  https://domain_name_or_IP/phpmyadmin

assas