Lots of websites use MySQL databases, including content management systems, e-commerce solutions, and forums. MySQL databases can be created from within your cPanel. When a database is created, there are three primary tasks:
- Create the database
- Create a database user
- Assign the user to the database
While cPanel allows you to do these tasks separately in the MySQL Databases section of the cPanel, it is much easier to use the MySQL Database Wizard as it will walk you through these steps.
To create a database using the Database Wizard, first log into your cPanel and click on "MySQL Databases Wizard" under the "Databases" sub-header:
On the next screen, put in the name for the database that you want to create. In this example, we will name it test2. Then click on "Create Database:"
Next we will create a user for the database. Put in the username that you want to use (all usernames will start with your Web Hosting Hub username), and enter a secure password. Then click on "Create user":
On the final screen, you will decide what privileges to give the user to the database. Unless you are creating a second user that you want to have limited access, click on "ALL PRIVLEDGES" and click on "Next Step":
You are done! You will get a confirmation page with the database that you just created: