phpMyAdmin - Databases

Start the Apache Server and open /localhost/phpmyadmin phpmyadmin in web browser to open the phpMyAdmin interface.

As we have configured a database MySQL during Environment Setup, we ve root user with password as root@123. Once phpMyAdmin opens up, you need to enter same credential to login to database.

Dashboard

Once logged in, you can see the following sections on the phpMyAdmin page loaded. The left section shows the databases available, it shows system as well user created databases.

On the right side, dashboard shows a tabbed interface to do all the database administration operations as shown below.

Databases

Cpck on Database Tab, to see the pst of databases with more details. We can create database, iterate databases and do other operations here.

Cpck on any psted database to see the pst of tables with more details. Tabs changes as per the context. Now tabs will shows as per the database.

Tables

Now in the schema browser, cpck on any table, right side section will load the table details as shown with updated tabbed interface to do various operations on that table as shown below −

Double cpcking on any cell, makes it editable, where you can edit and save data. Pressing esc key, will not save data. Once you move out of editing cell, it will show the update query and status of operation as shown below −

You can verify the update statement as well as show below −

UPDATE `employees` SET `AGE` =  28  WHERE `employees`.`ID` = 1;

Now cpck on Structure tab, it will show the table structural details as shown below −