phpMyAdmin
phpMyAdmin is a free open source application made in PHP. It is used to handle the administration of MySql through the use of a web browser. Before installing phpmyadmin, we will need a web server, Apache for example, PHP, MySQL and a web browser. I installed LAMP on my machine. Now you can install phpMyAdmin.
To access phpMyAdmin, through your web browser, go to localhost/phpmyadmin. You will see a login page. Enter the credentials you supplied during the setup of your phpmyadmin.
The phpMyAdmin homepage looks like the figure above. On the right side you can see your system information. On the left sidebar their is a list of databases.
You can see on the menu bar that their is a tab labeled SQL. You can use this to type in MySQL commands such as commands for creating tables and inserting, deleting and editing data. If you do not know the syntax of MySQL, phpmyadmin’s user interface gives you the ability to do the commands easily. For example, their is a button allowing you to create a table. On click of the button, a page will ask you the properties of the tables you will create. If you are finished with creating the table, an SQL script equivalent to the actions you made is generated. this feature of phpMyAdmin is very useful. You can reuse this script on your codes that access the same database.
