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 main purpose of the phpMyAdmin tool is to manage the databases.
Without any further delay, lets started…
Functionalities of PHPMyAdmin:
phpMyAdmin Databases tab:
When you open phpMyAdmin’s home page, click the Databases tab, and then pick a database to manage by clicking on its name.
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.
The possible actions to be taken at a table of your choosing are:
Through pressing the browse button you will see all the records inserted by you and you can show all the records in full detail.
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.
Clicking the structure button will show you all the work you can perform on a table Such as
fields name and their types
collations, attributes, null, comments, extra ,action
change drop and more option will see in action
Clicking on change will allow you to change all the field attributes.
Using the Search button you will create a search query for the chosen table.
Using the Query method to perform an example search. Just use different fields to arrange your search query, and press the Go button to execute it.
For 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). To see the results, click the Go button.
When you insert a record into a particular table, press the Insert button
You press the Empty button to delete all the inserted data from any table
You can press the drop button when you want to remove any record type of the database.
Clicking on the SQL tab an editor like a panel will be opened in this editor you can run your SQL query
You’ll find all the information of MySQL server in this section of PHPMyAdmin and u can see in the image below. In this section, you will see traffic and connection details
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. As you can see below.
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. the main part of your project that is the database that can be saved via the export tab.
This is also a very important feature in PHPMyAdmin in this section, you can import the database that you have exported. You can just click on the screen to choose and pick the file and press the go button