Becoming Familiar with Databases in PhpMyAdmin

Reading Time: 2 minutes

This tutorial assumes you’ve already logged in to PhpMyAdmin. Now let’s familiarize ourselves with databases and PhpMyAdmin.

From the home PhpMyAdmin screen, we have access directly to databases like lwtest_wpdb, listed here. A database consists of one or more tables, and it is in the tables that database information is recorded. 

01-01-Home_Page

From this PhpMyAdmin screen, we have access directly to the database demo1234_members, listed here. A database consists of one or more tables, and it is in the tables that database information is recorded. This particular database has two tables called details and information, and they are listed here. Click the database name just above them.

01-02-Table_View

We can Browse a table to see the individual records.

01-03-Browse

We can see the Structure of a table. This shows what type of data the field can hold, and the gold key icon shows that the option_id field is the primary key of this table.

01-04-Table_Structure

We can also Search through a table for specific information or ranges of data.

01-05-Search

We can also Insert new rows (records) into a table.

01-06-Insert_Row

We can Empty the contents of a table. This keeps the structure, but deletes all the data.

01-07-Empty_Table

Or, we can Drop (delete) an entire table altogether. This completely removes that table from the database.

01-08-Drop_Table

Then, clicking on the database name on the left-hand menu brings us back to the main structure tab.

01-09-Table_View_Again

The SQL tab lets us run a query on the database.

01-10-SQL_Tab

We can Search for a string or multiple words that appear in records within the tables that we select.

01-11-Search_Tab

The Query tab can help us build a query and sort the results.

01-12-Query_Tab

We can Export the database and save it to our local computer.

01-13-Export_Tab

We can Import previously exported databases.

01-14-Import_Tab

Then the Operations tab allows us to create a new table, rename the database, or even drop the entire database from here.

01-15-Operations_Tab

Clicking on this white paper icon in the upper left takes us to the Mysql Reference Manual.

01-16-Mysql_Documentation

The blue question mark icon takes us to PhpMyAdmin’s main documentation.

01-17-PhpMyAdmin_Documentation

The home icon takes us back to the home page.

01-18-Home

And the door icon logs us out of PhpMyAdmin!

01-19-Logout

Conclusion

From the PhpMyAdmin interface, we can see information about the tables contained in the database, as well as perform multiple actions within the tables and databases. We can Browse a table to see the individual records, view the Structure of the table, and perform Searches within a table for specific keywords. 

As seen above, we can Insert new rows (or fields) into a table, empty  (or delete) the contents of a table, or Delete (or drop) an entire table altogether. Alternatively, we can view the database Structure itself, open an SQL Query window for creating direct queries on the database to perform various types of searches. There is also a means to open an SQL Query window which provides an easy, step-by-step method to create queries.

Have further questions? Give us a call at 800.580.4985, or open a chat or ticket with us to speak with one of our knowledgeable Linux System Administrators to learn how you can take advantage of this technology today!

Series NavigationNext Article >>

Author Bio

About the Author: Alex Gorzen

Alex Gorzen has been helping others with technology his whole life. He played with computers even before he could read and wants to make sure his children share that same love as they grow up. In his free time he enjoys gardening, building things, and learning new skills.

Refer a friend and get a $50 hosting credit!