How to create a MySQL database in cPanel?
Creating a MySQL database in cPanel is a simple and necessary process for managing web applications and websites that require storing data in a MySQL database.
Follow the steps below to set up a database in cPanel:
Create the database
- Log in to your cPanel account with your credentials.
- Access “Manage My Databases” from the “Databases” section.
- In the “Create New Database” section, enter a name for the database and confirm with the “Create Database” button.
Creating a User
- From the "Manage My Databases" page, scroll to the "Add New User" section.
- Enter a username and password for the database account and confirm with the “Create User” button.
Add User to Database
- From the "Manage My Databases" page, scroll to the "Add User to Database" section.
- Select the newly created user and database and click “Add”.
- Select privileges individually or select “All Privileges”.
- Confirm with “Make Changes”.