You can create a new MySQL database within your cPanel account to store data for your website or application. This process allows you to establish a dedicated database and then assign a user to manage it.
Before you begin
You will need:
A valid cPanel account
The name of the database you wish to create
A chosen username for the database (if you wish to create a new user simultaneously)
Create a MySQL Database
Log in to your cPanel account.
Locate the Databases section and select MySQL® Databases.
Under the Create New Database section, enter a name for the new database.
Select the appropriate prefix and name from the text field.
Click Create Database.
Assign a User to the Database
After creating the database, you must assign a user to it to grant access.
Scroll down to the Add User To Database section.
Select the User from the first dropdown menu.
Select the Database from the second dropdown menu.
Click Add.
In the Privileges section, select the permissions you wish to grant the user (such as ALL PRIVILEGES).
Click Make Changes.
Confirm the result
The new database will appear in the list of databases in the MySQL® Databases interface.
The assigned user will now have the permissions required to access and manage that specific database.
Limitations
This procedure creates a standard MySQL database. If you prefer a guided setup that creates the database, a user, and assigns privileges in a single step, you may use the MySQL® Database Wizard instead.
