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
- Go to Databases > MySQL Databases.
- Under “Create New Database”, enter a name (cPanel prefixes it with your account username automatically) and click Create Database.
- Under “MySQL Users”, create a new user with a strong, generated password.
- 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.