MySQL® Database Wizard

Overview

This wizard guides you through the setup of a MySQL® database, user accounts, and user privileges. We recommend that you use this wizard to create your first database and user.

To create additional databases or users, you can also use the MySQL Databases interface (cPanel >> Home >> Databases >> MySQL Databases).

Set up a database

To set up a database, perform the following steps:

  1. In the New Database text box, enter a name for the database and click Next Step.

     2.  In the Username text box, enter a name for the user who you wish to allow to manage the database.

 

     3. Enter and confirm the new password in the appropriate text boxes.

        4. Click Create User.

        5. Select the checkboxes that correspond to the privileges that you want to grant the user, or select ALL PRIVILEGES.

         6. Click Next Step.

The system displays a message that states that you successfully set up the database and user account.

Additional options

After you complete the database setup process, select one of the following options:

  • Add another database — Click to return to the beginning of the MySQL Database Wizard interface to add more databases.

  • Add another MySQL Databases User — Click to open the MySQL Databases interface (cPanel >> Home >> Databases >> MySQL Databases) to create additional user accounts and assign them to a database.

  • Return to Home — Click to return to the cPanel Home interface.

More To Explore

Overview This interface allows you to view all of your mailboxes and remove old or large messages. Account Select the account to modify from the

Overview The Applications section of the cPanel interface displays applications (cPAddons) that your hosting provider has enabled for you. Note: You will only see this

Overview The Analog Stats interface allows you to access data from the Analog traffic statistics software. Analog compiles traffic statistics for your domain, and organizes