Search through a database using phpMyAdmin

Search through a database using phpMyAdmin

phpMyAdmin is a free web application which provides a GUI interface for working with MySQL database management system. It can import and export databases that are created and managed by MySQL DBMS and also with some other data formats. For searching through a database using phpMyAdmin, follow the below steps

Step 1: Login to cPanel

Step 2: In cPanel interface, go to database section

Step 3: Select the option phpMyAdmin under the section Database

Step 4: Select the database in the left side of the pane

Step 5: Click the option Search from the list of menus at the top of the page

Step 6: Enter the details need to be searched in the text box and and also select the table. Them click the option “Go”

Step 7: The search results will be displayed

Step 8: From the displayed search results, select the option browse to view the records in database

Step 9: Now the result will be displayed with actual query and a particular record

Step 1 Login to cPanel. You can directly login through your domain URL or you can access your cPanel via server URL.
Step 2 Go to Database Section.
Select Database option

Select Database option

Step 3 Select phpMyAdmin.
Select phpMyAdmin

Select phpMyAdmin

Step 4 Select the database in the left pane.
Select Database in the left pane.

Select Database in the left pane

Step 5 Select the Search option on the top of the page.
Select the search option

Select the search option

Step 6 Fill the necessary details in the text box and select the tables to want to search and  Click Go button to execute the search query.
Fill the necessary fields and click Go button

Fill the necessary fields and click Go button

Step 7 Search result will be displayed.
Now the result will be displayed

Now the search result will be displayed

Step 8 Select browse option to view the record in the database.
Select browse option

Select browse option

Step 9 The result will be displayed along with actual query and particular record.
Now the result will displayed.

Now the result is displayed

 

 

Tagged in:

, ,