HITENDRA PATEL

Many users not feel familiar with command line interface with the system from the MySQL, they need GUI interface like phpMyAdmin.

phpMyAdmin can connect with MySQL through a GUI interface.

In this blog, we’ll see how to install phpMyAdmin.

Before you get started, we need server with command line access allowed.

For that i use LINODE servers, if you don't have hosting server or you need to change your hosting provider, please refer below link.

Referral URL : www.linode.com

Step 1 : Update Ubuntu

We will install phpMyAdmin from the default Ubuntu repositories, but first need to update our system with latest packages.

sudo apt-get update

Step 2 : Install phpMyAdmin

Next, install phpMyAdmin from ubuntu repository, for that use following command line.

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

During this installation, we need to select some options like server, common setting, etc.

For the server choose apache, after the choose YES for default common configuration.

Next we need to enter password of our phpMyAdmin, so enter & store somewhere secure.

Step 3 : Enable PHP extensions

phpMyAdmin depends on some extensions from PHP to run smoothly.

For that run following commands :

sudo phpenmod mcrypt
sudo phpenmod mbstring

After that we need to restart our apache server.

sudo systemctl restart apache2

Step 4 : Run phpMyAdmin

Now all done here, need to check all run smoothly by pasting following url in your browser.

First replace ip with & port with your url.

http://127.0.0.1:8000/phpmyadmin

First screen asking you for credentials.

Use "root" as a username & password which you enter while installation.