MySQL Database Wizard

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:

• In the New Database field, enter a name for the database.

• Click Next Step.

• In the Username field, enter a name for the user allowed to manage the database.

• 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.

• Retype the password in the Password (Again) field.

• Click Create User.

• Select the privileges you wish to grant the user, or select ALL PRIVILEGES.

• 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.