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 data storage in a MySQL database.
Follow the steps below to set up a database in cPanel:
Creating the Database
- Log in to your cPanel account with your access credentials.
- Access Manage My Databases from the Databases section.
- In the Create New Database section, enter a name for the database and confirm by clicking the Create Database button.
Creating a User
- From the Manage My Databases page, scroll down to the Add New User section.
- Enter a username and password for the database account and confirm by clicking the Create User button.
Adding the User to the 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 individual privileges or select All Privileges.
- Confirm by clicking Make Changes.