When you create a database, many users are unaware that there are several other tasks that you need to do as well. The new database creation process actually involves:
- Creating a database
- Creating a database user
- Giving your database user access to work with your database
Luckily for us, cPanel includes a MySQL Database Wizard that walks you through each of these steps.
Creating a Database in cPanel Using the MySQL Database Wizard
WARNING: If you receive an error message regarding the limited number of databases available, you may consider upgrading your Business Class Hosting plan.
-
Next to Username enter a username.Enter a password next to Password, enter it again for Password (Again) and then click Create User.
-
On the next page, you'll assign privileges for the user to the database. Check the box next to All Privilegesand then click Next Step.
Congratulations! Now, you know how to successfully create a database.