Every dynamic site has a database. In cPanel you can create and manage one without touching the command line.
Creating a database
- In cPanel open Databases → MySQL Database Wizard.
- Give the database a name. The system prefixes it with your username — that is normal and cannot be changed.
- Create a user with a strong password.
- Assign the user to the database and tick ALL PRIVILEGES.
Those four details — database name, username, password and localhost as the host — are what you enter in your site's configuration file (in WordPress: wp-config.php).
phpMyAdmin
Under Databases → phpMyAdmin you can browse tables, run queries and export or import a database. Exporting before any significant change is a habit that saves sites.
Common mistakes
- Forgetting the prefix in the database or user name, which produces a connection error.
- Entering an external host name instead of
localhost. - Importing a large file through phpMyAdmin and hitting the size limit — in that case open a ticket and we will import it directly on the server.