How to Install phpMyAdmin on Ubuntu 18.04/16.04

In this article, We are going to perform How to Install phpMyAdmin on Ubuntu 18.04/16.04 LTS System.

Introduction

phpMyAdmin is most popular and free open source web based tool for MySQL and MariaDB adminstration.

Prerequisites

  • Ubuntu 18.04/16.04 with Minimal Installation
  • SSH Access with Sudo previleges
  • Preinstalled PHP and MySQL/MariaDB

Step 1: Install phpMyAdmin on Ubuntu

Update the system packages

$ sudo apt-get update

Install phpMyAdmin

$ sudo apt-get install -y phpmyadmin

While installing it will asks to select web server which you have installed on your system. Select apache2 and hit Enter.

How to Install phpMyAdmin on Ubuntu 18.04/16.04 1

Step 2: Configure phpMyAdmin on Ubuntu

It will ask to configure database for phpmyadmin which you have already installed. Select “Yes” and  Enter

How to Install phpMyAdmin on Ubuntu 18.04/16.04 2

Enter the password for phpmyadmin application.

How to Install phpMyAdmin on Ubuntu 18.04/16.04 3

Re-Enter the password again to confirm.

How to Install phpMyAdmin on Ubuntu 18.04/16.04 4

Next it will asks for Database administrator password. Type the password, Select “OK” and Enter.

How to Install phpMyAdmin on Ubuntu 18.04/16.04 5

Step 3: Enable mbstring Extension

Enter below command to enable mbstring.

$ sudo phpenmod mbstring

Enable phpMyAdmin in /etc/apache2/apache2.conf

$ sudo nano /etc/apache2/apache2.conf

Add below line at end of file.

Include /etc/phpmyadmin/apache.conf

To take effect restart apache2

$ sudo systemctl restart apache2

Step 4: Access phpMyAdmin

Open browser on your system and Type ServerName or IP , http://IP/phpmyadmin

How to Install phpMyAdmin on Ubuntu 18.04/16.04 6

Conclusion:

In this article, We have performed ,How to Install phpMyAdmin on Ubuntu 18.04/16.04 LTS System.

Related Articles:

How to Install MariaDB on Ubuntu 18.04/16.04 LTS

How to Install Memcached on Ubuntu 18.04/16.04 LTS

FOSS TechNix

FOSS TechNix (Free,Open Source Software's and Technology Nix*) founded in 2019 is a community platform where you can find How-to Guides, articles for DevOps Tools,Linux and Databases.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Share via
Copy link
Powered by Social Snap