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.
Set up a database
To set up a database, perform the following steps:
-
In the New Database text box, enter a name for the database and click Next Step.
Note:
The system limits the database name to 64 characters. However, due to the method that cPanel & WHM uses to store MySQL database names, each underscore character requires two characters of that limit. Therefore, if your hosting provider enabled database prefixing, the maximum length of the database name is 63 characters, which includes both the database prefix and the underscore character. Each additional underscore requires another two characters of that limit.
- In the Username text box, enter a name for the user who you wish to allow to manage the database.
-
Enter and confirm the new password in the appropriate text boxes.
- Click Create User.
- Select the checkboxes that correspond to the privileges that you want to grant the user, or select ALL PRIVILEGES.
- For more information about user privileges, read the official MySQL documentation.
- Click Next Step.
The system displays a message that states that you successfully set up the database and user account.
Additional options:
Add another database — Click to return to the start of the MySQL Database Wizard interface to add more databases.
Add another MySQL Databases User — Click to open the MySQL Databases interface (Home >> Databases >> MySQL Databases) to create additional user accounts and assign them to a database.