MySQL Database Wizard  Print this Article

cPanel can guide you through the setup of a MySQL database with the requisite accounts and privileges.

Set up a database

To set up a database with the MySQL Database Wizard, perform the following steps:

  1. In the New Database text box, enter a name for the database.
  2. Click Next Step.
  3. In the Username text box, enter a name for the user who is allowed to manage the database.
  4. In the Password text box, enter the user’s password.
    • The password must be seven letters or shorter.
    • To generate a strong password, click the Password Generator button.
  5. Reenter the password in the Password (Again) text box.
  6. Click Create User.
  7. Select the privileges that you want to grant the user, or select ALL PRIVILEGES.
  8. Click Next Step.

Next, cPanel will display a message that states that the database and user account were set up successfully.

Select one of the following three options:

  • Add another database — Returns to the start of the MySQL Database Wizard.
  • Return to Home

Note: When you add a user and database with 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.

Was this answer helpful?

Also Read

MySQL Databases
Databases allow you to manage large amounts of information easily over the web. They are...
phpMyAdmin Databases
phpMyAdmin is a third-party tool that is included with cPanel and is used for the management of...
Remote MySQL
Databases in cPanel can be accessed remotely by other web servers. This can be useful if you want...