Skip to main content
The Database Wizard bundles the three things you almost always do together (create a database, create a user, link them) into a four-step form. Faster than Manage My Databases when you’re starting clean. Open it from cPanel home → Databases → MySQL Database Wizard.
Database Wizard step 1 with database name field

​
Run through the wizard

1

Name the database

Type a short name. cPanel prefixes it with your account username automatically, so shop becomes username_shop. Click Next Step.
2

Create a user

Username (also auto-prefixed) and password. Use the Password Generator if you don’t have one ready. Copy the password to your password manager before clicking Create User. cPanel won’t show it again.
Database Wizard step 2 with username and password fields
3

Pick privileges

Check ALL PRIVILEGES at the top of the list for normal apps. Click Next Step.
Database Wizard step 3 with privileges checklist
4

Done

Confirmation screen with the database name, the user, and the privileges granted. Plug the values into your app’s config.
Where it ends upValue
Database hostlocalhost
Database nameusername_yourdbname
Database userusername_yourusername
PasswordThe one you set in step 2

​
When to use the wizard vs Manage My Databases

Wizard winsManage My Databases wins
Spinning up a new app from scratchAdding a second user to an existing database
You want one form, not threeRenaming, repairing, or deleting
You’ll set ALL PRIVILEGES anywayYou need fine-grained privilege control

​
Need a hand?