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.
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.
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?
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
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?
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.
After login, you will be able to see the phpMyAdmin web interface like this.
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.