Step 1: Open the Databases Section:

In cPanel, find the Databases section and click to expand it.

Step 2: Click "phpMyAdmin":

This opens phpMyAdmin, usually in a new tab. It will automatically log you in using your cPanel database credentials.

Step 3: Select a Database:

On the left sidebar, you'll see a list of all your databases. Click on the one you want to work with.

Step 4: Browse the Tables:

Once inside a database, you'll see all its tables listed. Click on any table to view its data.

Step 5: Edit or Delete Data:

While browsing a table, each row has Edit and Delete icons. Click Edit to modify a row's values, or Delete to remove it permanently.

Step 6: Insert New Data:

Click the Insert tab on a table to add a new row of data through a form.

Step 7: Run a Custom SQL Query:

Click the SQL tab at the top of the page, type your query (e.g., SELECT * FROM users WHERE id=5), and click Go to execute it.

Step 8: Export a Database (Backup):

1. Click on the database name in the sidebar.
2. Go to the Export tab.
3. Choose Quick (default) or Custom (more options).
4. Select the format (usually SQL).
5. Click Go to download the backup file.

Step 9: Import a Database (Restore):

1. Click on the database you want to import data into.
2. Go to the Import tab.
3. Click Choose File and select your .sql backup file.
4. Click Go to run the import.

Step 10: Manage Users and Privileges:

1. Go to the User accounts tab from the main phpMyAdmin home page.
2. Create a new user or edit an existing one.
3. Assign privileges per database (e.g, SELECT, INSERT, UPDATE, ALL PRIVILEGES).

Step 11: Optimize or Repair a Table:

1. Select the table from the list.
2. Go to the Operations tab.
3. Click Optimize table or Repair table as needed.