Previously we have talk about how to install and configure phpmMyAdmin on CentOS.
Here through the below steps we are explaining how to Install and Configure phpMyAdmin on Ubuntu server.
First of all, before installing anything new we have to make sure that the list of available packages is up to date.
apt-get -y update
Now we can install phpMyAdmin using the below command:
apt-get -y install phpmyadmin
As the installation runs you’ll be asked a few simple questions regarding the basic configuration of phpMyAdmin.
At the first screen, select apache2 , then hit enter to continue.
Next “configure the database for phpmyadmin with dbconfig-common?”, select Yes , then hit enter to continue.
At the third screen enter your MySQL password.
Finally at the fourth screen set the password you’ll use to log into phpmyadmin,and enter to continue.
To complete the configuration of Apache open the file:
vi /etc/apache2/apache2.conf
Add the following at the bottom of file:
phpMyAdmin Configuration Include /etc/phpmyadmin/apache.conf
Then exit and save the file,Restart Apache 2 with the following command:
service apache2 restart
Now the installation and configuration is completed. You can verify your phpMyAdmin is working by visiting the URL <YourserverIP>/phpmyadmin. For example: http://127.0.0.1/phpmyadmin.