phpMyAdmin tutorial will help you to become more familiar with phpMyAdmin databases and phpMyAdmin interface. We are going to assume that you are logged into your web hosting account on the web server. The control panel will show you the phpMyAdmin. When we open the phpMyAdmin the main screen is divided into two different screens. If you look at the blue section on the left, you can see the databases that are already present within your blog or website listed and you have a complete direct access.

As every one knows that the database consists of multiple tables, and it is in the tables that database information is recorded. In the blue screen, below any databases you have, it will list any tables in those databases. You can see the database name on the left hand side, the right hand screen opens up with information about that the tables contained in that database, as well as giving you the option of performing several actions. In that section, you will be allowed to perform several actions on each individual table. You can Browse a table to see the individual records. You can see the Structure of a table, and perform certain actions. You can Search for specific keywords in a table. You can easily update such as insert, delete, add, new rows (or fields) in the table. You can delete the contents of a table by clicking on the big red X, you can also delete the complete table.

There are multiple lists of action links at top of the window, you can get into and click on the link structure in the upper left corner to view the database structure. The next link is SQL, and it will open a SQL Query window for entering direct queries to the database. The next link is Search, you can click on it to perform a search. The following link is Query, which also opens a SQL Query window, but provides an easier step-by-step way to make queries. The next link is Export, which you can use to export databases to your local computer. The Import link will import previously exported databases. The Operations link can do a number of other operations, like creating new tables, and copying or renaming databases.

Whenever you return back to the blue section and click on a table name tab, the other screen will now display you the complete structure of the database table. It will list all the tables fields, along with the type of field, attributes, and other properties. If you scroll down, it will tell you which field is the Primary Key field. It provides lots of other information about the table, and has the same action links at the top of the screen that the database did. In the blue screen, right below the phpMyAdmin name, there is a row of icons. If your want further help with SQL you can click the icon that is for Documentation. It is a box, with SQL inside it. The box with the question mark will get you assistance with phpMyAdmin by clicking on it. The middle box, with the red SQL is another way of opening the SQL Query window. The icon with the Exit and arrow will log you out of phpMyAdmin. Clicking on the house returns you to the main screen.