Phpmyadmin is an open source software written on PHP iintended to handle the administration of MYSQL over web (internet). It provides a wide range of operations on MYSQL and other database.
Provides support for most MYSQL features like create, drop table. Create, copy, drop, rename and alter databases, tables, fields and indexes etc. Primary purpose of using phpmyadmin for web development is that it provides GUI for MYSQL. GUI helps developer to run sql syntax more easily as well management is much easier.
In order to install phpmyadmin LAMP should be installed properly.
Below provides tutorials for installation of phpmyadmin using command prompt
Step 1:- Open terminal and type command sudo apt-get install phpmyadmin, while installation 17.4Mb of additional disk use, so type ‘y’.
Step 2:- As installation progress, installation would ask for web server that would automatically configured to run phpmyadmin. Select apache2 and press ok
Step 3:- Installation also asked for “Whether to configure database for phyMyAdmin with dbconfig-common”. Select “YES” and proceed.
Step 4:- Provide password for database administrative user. (root)
Step 5:- After installation is complete, add phpmyadmin to apache configuration. Type command sudo gedit /etc/apache2/apache2.conf. (This is the path of directory where apache2 is install).
Step 6:- Scroll down and add the following lines at the end of file.
# Include phpmyadmin configuration
Save and exit.
Step 7:- Restart apache2 server. Type command sudo service apache2 restart
Step 8:- Open browser and type localhost/phpmyadmin or 127.0.0.1/phpmyadmin
Step 9:- Provide username and password that was provided in step 5. (root)