Knowledgebase

MySQL Database Wizard

For cPanel version 11.32

cPanel can guide you through the process of setting up a MySQL database, along with the requisite accounts and privileges, step by step.

To set up a database using the MySQL Database Wizard:

  1. In the New Database field, enter a name for the database.
  2. Click Next Step.
  3. In the Username field, enter a name for the user allowed to manage the database.
  4. In the Password field, type the user’s password.
    • The password must be 7 letters or shorter.
    • For help generating a strong password, click the Password Generator button.
  5. Retype the password in the Password (Again) field.
  6. Click Create User.
  7. Select the privileges you wish to grant the user, or select ALL PRIVILEGES.
  8. Click Next Step.

Next, cPanel will display a message stating that the database and user account were successfully set up. From here, you may select 1 of 3 options:

 

  • Add another database — Returns to the start of the MySQL Database Wizard.
  • Add another user using the MySQL Databases Area — Opens the MySQL® Databases page, wherein you may create additional user accounts and assign them to a database.
  • Return to Home — Opens the cPanel home screen.

Note: When you add a user and database using the MySQL Database Wizard, the user is automatically given access to the database; there is no need to use the Add User to Database feature.

  • 8 Users Found This Useful
Was this answer helpful?

Related Articles

Accessing cPanel

To access cPanel: Type: http://www.yourwebsite.com.au/cpanel into your preferred Internet...

The cPanel Home Screen

For cPanel version 11.32 The cPanel home screen provides access to all of your cPanel functions....

The Getting Started Wizard

For cPanel version 11.32 Once you have logged in, the start-up wizard is presented. This wizard...

Video Tutorials

For cPanel version 11.32 Clicking this icon will open a web page where various video tutorials...

Accessing Webmail

For cPanel version 11.32 To access webmail: Type: http://www.yourwebsite.com.au/webmail into...