How to Manage Databases with phpMyAdmin

How to Manage Databases with phpMyAdmin?

---

phpMyAdmin is a free, browser-based tool for managing MySQL databases. It allows you to view and edit database tables, run SQL queries, import/export data, and manage database users — all without needing to know command-line SQL.

Accessing phpMyAdmin

1. Login to cPanel.
2. Under Databases, click phpMyAdmin.
3. phpMyAdmin opens in a new tab showing all your databases on the left panel.

Key Operations in phpMyAdmin

Browse/Edit Table Data:

1. Click a database, then a table name.
2. Click Browse to see all rows.
3. Click the pencil icon to edit a row.

Run a SQL Query:

1. Select the database.
2. Click the SQL tab.
3. Type your SQL query and click Go.

Export Database:

1. Select the database.
2. Click Export.
3. Choose Quick export method and SQL format.
4. Click Go to download the .sql file.

Import Database:

1. Select the target database.
2. Click Import.
3. Choose the .sql file and click Go.

Tip: For large databases (>50MB), phpMyAdmin may time out during import. In that case, use SSH to import via command line: mysql -u user -p dbname < backup.sql

If you continue to face issues, please open a create a request.