Databases enable easy management of large amounts of data via the web. They are required for the proper functioning of a large number of web-based applications. The process of creating a new database entails the following:
- Creating a database
- Creating a database user
- Granting permission for database user to interact with your database
Fortunately, cPanel comes with a MySQL Database Wizard that guides you through each of these steps.
Step 1:
Login to your cPanel
Step 2:
Click the MySQL Database Wizard under the Databases Section
Step 3:
Provide a name for your database and on click Next Step.
Step 4:
Following that, enter your desired database username, password and confirm your password again. Following that, click on Create User Button.
Step 5:
On the next page, you’ll assign privileges for the user assigned to the database. Check the box All Privileges and proceed to the Next Step
Congratulations! Now, you know how to successfully create a database.
