How do I create a MySQL database in my control panel (cpanel)?Written by Brad Markle
Click here to watch a video tutorial
When you create a database, many users are unaware that there are several other items 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:
- Log into your cPanel
- Click the MySQL Database Wizard under the Databases heading
- Next to New Database enter a name for your database and click Next Step
- 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 Privileges and then click Next Step.
Congratulations, you have just successfully created a database!
Now that the database is set up in your cPanel, you will need to add a user to the database. Please see our article on How to create and attach a database user in cPanel.