Client Zone Knowledgebase ezywebhosting Databases Create a database and user

Create a database and user

Print
mysql, database 0

Most website apps, such as WordPress, need a database and a database user. cPanel's Database Wizard creates both and connects them in one go.

Updated 19 November 2026Applies to cPanel web hosting

What you'll need

  • A cPanel sign-in for your hosting
  • Somewhere safe to note the database name, username and password

Installing an app with Installatron? It normally creates the database as part of the install, so you may not need this guide.

Create a database and user

  1. Open the Database Wizard

    In cPanel, go to Databases > Database Wizard.

  2. Name the database

    Type a short name in New Database and select Next Step. If cPanel shows your account name and an underscore before the box, that prefix becomes part of the name, so shop becomes something like youracct_shop. Note the full name.

  3. Create its user

    Enter a Username (it gets the same prefix, if any) and a strong Password, then select Create User.

  4. Give the user access

    Tick ALL PRIVILEGES and select Next Step. Your app can now use the database.

  5. Tell your app

    Your app asks for four things:

    Database nameThe full name, with the prefix
    UsernameThe full username, with the prefix
    PasswordThe one you set in step 3
    Hostlocalhost

Create databases here, not in phpMyAdmin. Databases made in phpMyAdmin aren't known to cPanel, so they're left out of backups and restores.

What's next

Follows cPanel's documentation: "Database Wizard" and "Manage My Databases" (docs.cpanel.net, November 2026).

Was this guide helpful?

Still stuck?

Send us the details and our team will take it from here

Open Ticket