How To Set up a database
How To Set up a database
To set up a database, perform the following steps:
1 – Open cPanel (yourdomain/cpanel).
2 – Click on (MySQL® Databases) from Databases section.
3 – In the New Database text box, enter a name for the database and click Next Step.
4 – In the Username text box, enter a name for the user who you wish to allow to manage the database.
5 – Enter and confirm the new password in the appropriate text boxes.
6 – Click Create User.
7 – Select the checkboxes that correspond to the privileges that you want to grant the user, or select ALL PRIVILEGES.
8 – Click Next Step.
The system displays a message that states that you successfully set up the database and user account.
Additional options
After you complete the database setup process, select one of the following options:
- Add another database — Click to return to the beginning of the MySQL Database Wizard interface to add more databases.
- Add another MySQL Databases User — Click to open the MySQL Databases interface (cPanel >> Home >> Databases >> MySQL Databases) to create additional user accounts and assign them to a database.
- Return to Home — Click to return to the cPanel Home interface.
Video: