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 Generate Password button.
  5. Retype the password in the Password (Again) field.
  6. Click Next Step.
  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:

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.


Was this answer helpful?
Also Read
How to create and use MySQL database (Views: 618)
Index Manager (Views: 675)
HotLink Protection (Views: 676)
Subdomains (Views: 677)
IP Deny Manager (Views: 692)

Powered by WHMCompleteSolution