Installing phpMyAdmin on Ubuntu 18.04 LTS

phpMyAdmin is a free, open-source web-based database management tool written using PHP programming language. It allows the database administrators to manage single or multiple database servers either from a local or remote system using a web browser. Using phpMyAdmin, we can create, delete, rename, edit databases, tables, fields, and also we can directly execute any SQL commands.

Step.1: Open the terminal and type the following commands one by one

sudo apt-get update

sudo apt install phpmyadmin php-mbstring php-gettext

sudo phpenmod mbstring && sudo systemctl restart apache2

During the installation, a box will appear to choose the web server that should be automatically configured to run PHPMyAdmin. Choose apache2 and click OK.

Again it will ask for the password for PHPMyAdmin. Enter the password and re-enter it again to confirm.

2. Open the web browser and type

    http://localhost/phpmyadmin or server-ip_address/phpmyadmin 

3. If phpMyAdmin doesn't load please edit the following file.

sudo gedit /etc/apache2/apache2.conf

Add the following line at the end

Include /etc/phpmyadmin/apache.conf

In case you could not log in to phpMyAdmin  with root user create another user

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Reference
https://help.ubuntu.com/lts/serverguide/phpmyadmin.html