Managing Databases with phpMyAdmin

Overview: How to create, manage, and delete databases using phpMyAdmin.

Content:

Accessing phpMyAdmin

1. Log into cPanel:

   • Navigate to your cPanel login page and enter your credentials.

2. Navigate to the “phpMyAdmin” Section:

   • Click on “phpMyAdmin” under the “Databases” category.

Creating a Database

1. Open phpMyAdmin:

   • Click on “Databases” tab.

2. Create New Database:

   • Enter the database name.
   • Click “Create.”

Managing Databases

1. Select a Database:

   • Click on the database name in the left-hand sidebar.

2. Perform Database Operations:

   • Tables: View, edit, or delete tables within the database.
   • SQL: Execute SQL queries directly.
   • Export: Export the database in various formats (e.g., SQL, CSV).
   • Import: Import data into the database from an external file.

Deleting a Database

1. Open phpMyAdmin:

   • Click on the database name in the left-hand sidebar.

2. Delete Database:

   • Go to the “Operations” tab.
   • Click “Drop the database (DROP)” and confirm.