How to Use phpMyAdmin in cPanel

Open phpMyAdmin

1. Go to Databases > phpMyAdmin.
2. Wait for phpMyAdmin to open in a new screen or tab.

3. Select the database from the left menu.

Browse a Table

1. Select the database.
2. Click the table name.
3. Click Browse.
4. Review the rows in the table.

Run a SQL Query

1. Select the database.
2. Click SQL.
3. Enter the query.

4. Click Go.

Export a Database

1. Select the database.
2. Click Export.
3. Choose Quick for a standard export.
4. Choose SQL as the format.

5. Click Export.

Import a Database

1. Select the database.
2. Click Import.
3. Click Choose File.
4. Select the SQL file from your computer.
5. Click Import or Go.

Notes

• phpMyAdmin works directly with database data.
• Export a copy before making major changes.
• Be careful with SQL queries, especially DELETE, DROP, and UPDATE queries.