Back to knowledgebase

How to Use MySQL Database Wizard in cPanel

MySQL Database Wizard screen in cPanel

Create the Database

  1. Go to Databases > MySQL Database Wizard.
  2. Enter the database name.
Database name entered in MySQL Database Wizard
  1. Click Next Step.

Create the User

  1. Enter the database username.
  2. Enter and confirm a strong password.
Create MySQL user screen
  1. Click Create User.

Choose Privileges

  1. Tick All Privileges for a normal website database user.
  2. Or choose only the privileges required.
MySQL user privileges screen
  1. Click Next Step.

Use the Database Details

  1. Copy the full database name.
  2. Copy the full database username.
  3. Use the password you created.
  4. Set the database host to localhost unless your application says otherwise.

Notes

  • MySQL Database Wizard is a guided version of the MySQL Databases screen.
  • The full database name and username usually include your cPanel username as a prefix.