A database is where your website keeps its memories: posts, products, orders and user accounts. WordPress, Joomla, PrestaShop and most other web applications need one. Here's how to make one in cPanel, with its own user and password.
The quick way: Database Wizard
- Log in to cPanel and go to Databases > Database Wizard.
- Step 1: type a name for your database and click Next Step.
- Step 2: type a username, set a strong password (or use Password Generator) and click Create User.
- Step 3: tick ALL PRIVILEGES and click Next Step.
- Done! Romeo shows you a happy summary.
The manual way: Manage My Databases
1. Create the database
- Go to Databases > Manage My Databases.
- Under Create New Database, type a name after the prefix (for example
shop). - Click Create Database, then Go Back.
2. Create a database user
- Scroll down to Database Users > Add New User.
- Enter a Username, a Password twice (watch the Strength meter; aim for green).
- Click Create User, then Go Back.
3. Introduce them to each other
A database and a user are strangers until you introduce them:
- Under Add User To Database, choose your User and Database.
- Click Add.
- Tick ALL PRIVILEGES and click Make Changes.
Why does my database name have a prefix?
cPanel always adds your cPanel username in front, like abcd1234_shop. Use the full name (with prefix) in your website's configuration, for both the database and the user.
What to put in your website's settings
| Setting | Value |
|---|---|
| Database host | localhost |
| Database name | cpaneluser_shop (full name) |
| Username | cpaneluser_shopuser (full name) |
| Password | the one you set |
Romeo's tip: Installing WordPress with Softaculous? It creates the database for you, so you can skip all of this.






