This article applies to cPanel clients
This guide will explain the procedure for creating databases using the MySQL Wizard (Database Wizard) offered by cPanel. The process through which to configure a MySQL database will be explained step by step, with the account and privilege requirements.
To configure a database using the wizard, follow these steps:
-
Enter cPanel and go to "Databases> MySQL Wizard".
-
In the "New Database" field, enter the name you want to give to the database.
-
Press the "Next Step" button.
-
In the "Username" field, enter a name for the user who will be allowed to administer the database.
-
In the "Password" field, enter the password for the user, it must be 7 letters or less, you can generate a secure password by clicking on the "Generate Password" button.
-
Enter the password again to confirm.
-
Press the "Next Step" button.
-
Select the privileges you want to give the user, or select "All Privileges" (ALL PRIVILEGES)
-
Press the "Next Step" button.
Then cPanel will return a message indicating that the database and user account have been configured successfully. From here, you can select 1 of 3 options:
-
Add another database: Selecting this option will return you to the start of the MySQL Wizard.
-
Add another user using the MySQL Databases Area: This option will open the MySQL database page, where you can create additional user accounts and assign them to a database.
-
Return to Home: Open the main page of cPanel.
Note: When adding a user and a database using the MySQL Wizard, the user is automatically given access to the database, there is no need to use the "Add User to Database" tool. to Database).