Most website applications, including WordPress, store their content in a MySQL (MariaDB) database. Creating one takes three steps: the database, a user, and the connection between them.
- In cPanel, open Databases › Manage My Databases.
- Under Create New Database, enter a name, for example
shop, and click Create Database. - Under MySQL Users › Add New User, enter a username and a strong password, and click Create User. Save the password; you will need it in the next step.
- Under Add User To Database, select the new user and database and click Add.
- Tick ALL PRIVILEGES and click Make Changes.
Connecting your application
| Setting | Value |
|---|---|
| Database host | localhost |
| Database name | Your cPanel username, an underscore and the name you chose, for example username_shop |
| Database user | Shown in the same format, for example username_shopuser |
| Password | The password you set in step 3 |
For security, databases accept connections only from websites on our server. If you need to connect from your own computer, please contact support.