How to Use cPanel’s MySQL Databases & phpMyAdmin

Almost every dynamic website — WordPress included — stores its content in a MySQL database. Here’s how that database gets created and managed on cPanel hosting.

Creating a database

1. Go to Databases > MySQL Databases.
2. Under “Create New Database”, enter a name (cPanel prefixes it with your account username automatically) and click Create Database.
3. Under “MySQL Users”, create a new user with a strong, generated password.
4. Under “Add User to Database”, select the user and the database, then grant All Privileges (unless you specifically need a restricted-permission user).

Most application installers (WordPress, etc.) will ask for the database name, username, password, and host (almost always localhost on shared hosting) — exactly what you just created.

Opening phpMyAdmin

Under Databases > phpMyAdmin, select your database from the left sidebar to browse its tables. This is a full visual interface to the database — no command line required.

Common phpMyAdmin tasks

• Browse/edit data — click a table, then Browse, to see rows; click Edit on any row to change values directly (useful for a quick WordPress option change without wp-admin access).
• Run a SQL query — the SQL tab lets you run any query directly, useful for bulk find-and-replace operations (e.g. after a domain migration, updating URLs stored in post content).
• Export a backup — select the database, click Export, choose “Quick” and SQL format, and download a full .sql dump.
• Import — create/select an empty database first, then use the Import tab to upload a .sql file to restore it.

A safety habit

Before running any direct SQL edit or bulk query in phpMyAdmin, export a quick backup of at least the affected table first — a manual UPDATE query without a WHERE clause is one of the most common ways to accidentally wipe an entire table’s data.