How to Create a MySQL Database in cPanel

Dynamic sites and applications need a database plus a database user with privileges. The MySQL Database Wizard creates all three in one pass.

Step-by-step

1. Open Databases → MySQL Database Wizard in cPanel.
2. Name the database (e.g. shopdb). cPanel prefixes it with your account name: youruser_shopdb. Click Next Step.
3. Create the database user. Pick a username (also prefixed) and generate a strong password — note all three values down. Next Step.
4. Grant privileges. Tick ALL PRIVILEGES for a normal website user → Next Step. Done.
5. Use the values in your application config: database host = localhost, database name = youruser_shopdb, username = youruser_dbuser, password = the one you saved.
6. Manage later under Databases → Manage My Databases — add users, change privileges, rename or delete.