Here you’ll learn installation and configuration of your favorite open source tool called phpMyAdmin.
What is phpMyAdmin?
phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.
All php developer already know about this free tool, It by default inbuilt some windows/mac software called WAMP, XAMPP, MAMP etc.
But here i’ll show you how to configure phpMyAdmin in your ubuntu machine with LAMP Server.
I assume that you already have LAMP Stack installed in your ubuntu machine.
Step-1:- Run below command to install phpMyadmin in your machine.
sudo apt-get install phpmyadmin
At the time of installation it may ask for your database username and password.
Step-2:- Edit your apache configuration file.
sudo vim /etc/apache2/apache2.conf OR sudo nano /etc/apache2/apache2.conf
You can use any command line text editor to edit system file like nano or vim.
Step-3:- Now include the path of the phpMyadmin apache conf file.
Step-4:- Restart your apache server.
sudo service apache2 restart
Now finally run your phpmyadmin tool on browser.
And enter your mysql username and password to access mysql database details.