How to use the cPanel MySQL Database Wizard

With the cPanel MySQL Database Wizard, you can easily create a database and set up a user for it.

How to use the MySQL Database Wizard:

  1. Log in to your cPanel account
  2. Go to MySQL Database Wizard (DATABASES section)
  3. Step1. Enter the new database name. Click the Next Step button.
  4. Step2. Enter the Username and the Password you want. (you can use the Password Generator) Click the Create User button.
  5. Step3. Now we need to add the user to the database. Select the privileges you want the new user to have on the database. Select ALL PRIVILEGES.  You can also select specific privileges, as:
    ALTERCREATECREATE TEMPORARY TABLES
    DELETEEVENTINDEX
    ALTER ROUTINECREATE ROUTINECREATE VIEW
    LOCK TABLESSELECTTRIGGER
    DROPEXECUTEINSERT
    REFERENCESSHOW VIEWUPDATE

    Click the Next Step button.

  6. Step 4. Nothing to do here. Everything is completed.
cPanel MySQL Database Wizard

The how-to movie:

cPanel MySQL Tools

Related KB: Working with cPanel MySQL Databases

Leave a Reply