We have a new documentation site for cPanel & WHM! You can find our new documentation site at docs.cpanel.net.
We will continue to maintain our API documentation on this server.
For cPanel & WHM 11.48
(Home >> Databases >> MySQL Database Wizard)
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 (Home >> Databases >> MySQL Databases).
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.
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.
MySQL limits the database username to 16 characters. The system includes the database prefix in the character count for the username.
db_prefix would allow usernames up to 13 characters long.
example_prefix would allow usernames up to eight characters long.
Enter and confirm the new password in the appropriate text boxes.
0indicates a weak password, while
100indicates a very secure password.
The system displays a message that states that you successfully set up the database and user account.
After you complete the database setup process, select one of the following options:
When you use the MySQL Database Wizard interface to add a user and a database, the system automatically grants the user access to the database. You do not need to use the Add User to Database feature in the MySQL Databases interface (Home >> Databases >> MySQL Databases).