You can create a MySQL database in cPanel using either the MySQL Databases tool for manual, step-by-step control or the MySQL Database Wizard for a guided process. Both methods require you to create a database, a database user, and then connect them with assigned permissions.
Using the MySQL Database Wizard
The wizard is the simplest option and is recommended for most users.
Log in to cPanel. Access your cPanel account, typically via a link from your web host’s control panel.
Navigate to the Databases section and click on “MySQL Database Wizard”.
Step 1: Create a Database
Enter a name for your new database and click “Next Step.” Your cPanel username will be automatically prepended as a prefix to the name you enter (e.g., cpaneluser_database).
Step 2: Create a Database User
Enter a username and create a strong password. It is recommended to use the Password Generator for a secure password. Click “Create User.”.
Step 3: Assign Privileges
On the next page, you will grant permissions to the user you just created. For most applications, selecting the “ALL PRIVILEGES” checkbox is the correct choice. Click “Next Step.”.
Step 4: Complete the Task
You will see a confirmation page. The process is now complete, and your database, user, and permissions have been created and assigned.
Ready for a Faster, Smarter Website?
Launch Your Cloud Hosting Now – Highlight: Experience LiteSpeed speeds and powerful cPanel control with Hostmara.
What to do next
After completing either method, be sure to save the following credentials, as you will need them to connect your application (such as a CMS like WordPress or web script) to the database:
- Database Name (e.g., cpaneluser_database)
- Database User (e.g., cpaneluser_user)
- Database Password (the one you set during the process)
- Database Host (usually localhost)