How to create a database and a database user Print

  • database, mysql, wizard
  • 0

Some website software, such as WordPress, stores its content in a database. You create the database and a user who can use it. The Business Email plan does not include databases.

Use the Database Wizard (easiest)

  1. Sign in to cPanel and open Database Wizard.
  2. In Step 1: Create A Database, type a name after your account prefix and continue.
  3. Follow the next steps to create a database user and give it access to the database.

Or do it in two parts

  1. Open Manage My Databases.
  2. Under Create New Database, type a name after the prefix in New Database and create it.
  3. Under Database Users and Add New User, type a Username and a Password twice. The Strength meter shows how strong the password is.
  4. Under Add User To Database, choose the User and the Database, and add the user. Grant the privileges your software needs.

Write these down for your website software

  • The full database name, including the prefix.
  • The full database username, including the prefix.
  • The password you chose.
  • The host name, which is usually localhost.

Change a database password or remove a database

On Manage My Databases, the Current Users list has Change Password, Rename and Delete. The Current Databases list has Rename and Delete. Deleting cannot be undone.

If you change a database password, update it in your website software too.


Was this answer helpful?

« Back