How to Use phpMyAdmin

phpMyAdmin is a popular and free open source application written in PHP for MySQL databases management. It’s one of the most popular applications and MySQL administration tools, with a large community of users and contributors.

PhpMyAdmin allows you to perform a wide range of operations with MySQL. In this tutorial, we’ll familiarize ourselves with databases and phpMyAdmin.

1) Log into cPanel

2) Look for the “DATABASES” section and click on “phpMyAdmin “, you’ll be redirected to the phpMyAdmin interface.

3) From this new screen, we have direct access to all the databases created under this cPanel account, they are all listed on the left side. In this example, we have the databases “chemiclo_demo” and “information_schema“. A database consists of one or more tables, the information is recorded in the tables.

4) You can also view all the databases created under this account if you click the “Databases” tab:

Let’s have look at the options available in the top menu from phpMyAdmin

  • From the SQL tab, we can open an SQL Query window, here we can enter an entire SQL query code and execute it by pressing “Go“.
  • In the Status tab, we’ll find information regarding the MySQL server since the last restart, like the MySQL uptime, number of active connections and traffic volume.
  • We can export databases to our local computer if we click on the Export tab and hit “Go”.
  • We can import databases from our local computer if we click on the Import tab and hit “Go”.
  • In the Variables tab, you’ll see will see a list of the MySQL server system variables.
  • In the Charsets tab, you’ll find all the charsets and collations supported by the MySQL server.
  • In the Charsets tab, you’ll see a list with all the engines supported by the MySQL server

Let’s move back to the current databases installed on this cPanel account

If we click on the chemiclo_demo database all the tables created under this database will be listed. As we can see in this screen, this database has only 3 tables created.

From here we can see more information about the tables contained in the database, as well as perform several actions:

  • Browse a table to see the individual records.
  • See the Structure of a table and perform certain actions.
  • Search through a table for specific keywords.
  • Insert new rows (or fields) into a table.
  • Empty or delete the contents of a table.
  • Delete or drop an entire table altogether.
Updated on March 25, 2020

Was this article helpful?

Related Articles

TRY CHEMICLOUD RISK-FREE
Fast, secure cloud hosting. 18 global data centers. Unhappy with your web host?
👉 Migrate for Free

Leave a Comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.