Help center

How to Create a MySQL Database and User

Updated November 5, 2026

You can create a MySQL database, user, and database permissions in cPanel using Database Wizard. You can also complete each part separately in Manage My Databases.

Using Database Wizard

  1. In cPanel, open Database Wizard.
  2. Enter a name for the database and continue.
  3. Enter a username and password for the database user, then continue.
  4. When asked to assign privileges, select All Privileges and finish the wizard.

Using Manage My Databases

  1. Open Manage My Databases.
  2. Create the database with a name such as mydata.
  3. Create a database user and set its password.
  4. Add the user to the database, select All Privileges, and apply the changes.

cPanel may add your account username to the beginning of the database and user names, separated by an underscore. Use the complete database name, username, and password when setting up your website or app. Keep these details private.

If something doesn’t work

Check that you are using the complete database and user names, that the user has been added to the correct database, and that all required privileges were selected. If you still need help, open a ticket with the database name and the error message, but do not include the password.

Still stuck?

Sign in and open a ticket, and we'll help.

Sign in and open a ticket