best web hosting

Install phpMyAdmin on Ubuntu 16.04

Do you want to manage your MySQL databases without using MySQL prompt? Are you looking for a user-friendly web interface to manage your MySQL databases & tables? Do you want to install phpMyadmin with ease?

If yes, then this guide is for you. In this guide, I will show you how you can easily install phpMyAdmin on Ubuntu 16.04. I will try to explain you every step as easy as possible. At the end of this guide let me know your views.

Introduction:

phpMyAdmin was created with the purpose to ease the operations required to manage databases, It is a web interface where you can easily add, update and delete the databases, it’s tables and table contents. Keep a note that phpMyAdmin is not a database it is just a web interface where you can manage your databases, in this case, the database is MySQL. Check out the features.

In this guide, we will discuss how to install and secure phpMyAdmin on Ubuntu 16.04. Before proceeding with actual installation process kindly read the prerequisites section carefully to avoid misconfiguration of your server.

Prerequisites

Before you proceed further with this guide, you need to make sure you have completed the below-given points.

  • I assume that you have a server installed with Ubuntu 16.04 operating system with a user having root privileges.
  • Before you start the installation of phpMyAdmin on the server make sure you have installed LAMP stack i.e Apache, MySQL, and PHP on the server, if not then read and follow this guide first How to install LAMP on Ubuntu 16.04?

It is very important to complete the above-mentioned steps before you start installing the phpMyAdmin on Ubuntu 16.04.

Install phpMyAdmin

To install phpMyAdmin we will simply pull the phpMyAdmin package from Ubuntu repository and install it on the server, to accomplish our task we will use Ubuntu Package Manager apt. 

First, update the server local package index if it’s not already done.

sudo apt-get update

Pull the package from the repository. Before installing this package we need mbstring PHP extension or else you will get an error message about missing mbstring while installing the package.

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

Now the installation will start and it will ask you whether you want to continue or not, select Y and hit enter.

Step 1: Select Web Server

Installl phpMyAdmin

By default no option is selected, you have to select the web server first, select apache2 as your web server by pressing the space bar.

Step 2: Configure database for phpmyadmin with dbconfig-common?

Install phpMyAdmin Ubuntu

By default is <Yes>, press enter. Do not select <No>

Step 3: Enter MySQL password

This is the same password which you have entered while installing MySQL if you are followed my last post step by step How to install LAMP on Ubuntu 16.04? I told you to remember your password as we need to enter the same password here while installing the package.

Now you have successfully installed phpMyAdmin on Ubuntu 16.04 server, the configuration file is stored in /etc/apache2/conf-enabled/ directory and the server will read configuration from there, but we need to explicitly enable the mcrpyt and mbstring.

root@technomania:~# sudo phpenmod mcrypt
root@technomania:~# sudo phpenmod mbstring

Restart the apache so that changes take effect.

sudo systemctl restart apache2

Now, you can access the web interface by using your server IP as shown below. Replace [server-ip-address] with your server IP.

http://[server-ip-address]/phpmyadmin/
phpMyAdmin

phpMyAdmin

After login, you will be able to see the phpMyAdmin web interface like this.

Conclusion:

As you have installed phpMyAdmin on Ubuntu 16.04 server, you will now be able to access your databases and tables using the Web Interface. You can easily perform all database SQL operations like Select, Update, Delete with the easy to use Web Interface. Most of the web artisans prefer phpMyAdmin to manage their databases and tables.

Kindly let me know if you face any issues while following my step by step guide on How to install phpMyAdmin on Ubuntu 16.04? You can comment your problems below and I will try to resolve your query as soon as possible. If you like this article don’t forget to share this with your friends & colleagues. If you find my articles are helpful then do subscribe to our newsletters.

Thank you for reading.

best web hosting

Add Comment

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