This is the most important feature of PHPMyAdmin in this section, you can export your database and save the data on your computer because if you lose the project so you have a copy of you project database. In this section of PHPMyAdmin, you can find everything about user account s in this section where you can find your username and password for your localhost. In this section, you will see traffic and connection details

You’ll find all the information of MySQL server in this section of PHPMyAdmin and u can see in the image below. You can press the drop button when you want to remove any record type of the database.Ĭlicking on the SQL tab an editor like a panel will be opened in this editor you can run your SQL query You press the Empty button to delete all the inserted data from any table When you insert a record into a particular table, press the Insert button Just use different fields to arrange your search query, and press the Go button to execute it.įor example, you should first select the fields you want to show if you want to view all records with a field value beginning with “a.” Choose the LIKE operator from the drop-down menu, and enter the corresponding field value “a percent” (percent is a wildcard string). Using the Query method to perform an example search. Using the Search button you will create a search query for the chosen table. You can update the record data in a table after updating the data by clicking the edit button and then click the go button to save all the data you are updating.Ĭlicking the structure button will show you all the work you can perform on a table Such asĬollations, attributes, null, comments, extra ,actionĬhange drop and more option will see in actionĬlicking on change will allow you to change all the field attributes. Through pressing the browse button you will see all the records inserted by you and you can show all the records in full detail. The possible actions to be taken at a table of your choosing are: Browse On the page that opens you will see a list of the database tables, the activities permitted with them, the number of records, the storage system, the collation, the sizes of the tables, and the overheads. When you open phpMyAdmin’s home page, click the Databases tab, and then pick a database to manage by clicking on its name. The main purpose of the phpMyAdmin tool is to manage the databases.įunctionalities of PHPMyAdmin: phpMyAdmin Databases tab: PhpMyAdmin localhost 8080 various functionalities using Wamp server-in this article you will learn about the various functionalities of PHPMyAdmin using localhost 8080 for that I am using wamp server. The possible actions to be taken at a table of your choosing are:.

Http localhost 8080 phpmyadmin