When do I need a database?
If you install WordPress, Joomla, PrestaShop, or other applications, they need a MySQL database to save your content, users, and settings. If you use Softaculous, the database is created automatically. If you install manually, follow these steps.
Step 1 — Access the MySQL Wizard in cPanel
- Log in to cPanel
- Find the "Databases" section
- Click on "MySQL Database Wizard"
Step 2 — Create the database
In the "New Database" field, type a name. For example: mystore. cPanel will automatically add your user prefix, resulting in something like: user_mystore.
Click on "Next Step".
Step 3 — Create the user
Enter a username and a secure password. You can use cPanel's password generator. Click on "Create User".
⚠️ Save this information:
You will need the database name, username, and password when configuring your application.
You will need the database name, username, and password when configuring your application.
Step 4 — Assign the user to the database
Select the user you created and the database. Check "All Privileges" and click on "Make Changes".
✅ Done! Your database is created. You can now use it in your application. The data you need is:
Host: localhostDatabase: user_mystoreUser: user_myuserPassword: the one you choseManage with phpMyAdmin
From cPanel → phpMyAdmin you can view, edit, export, and import your database using a visual interface.