Table of Contents

cPanel Manage Databases

MySQL Databases allow you to store information in an easy-to-access manner. Web applications require databases ( like MySQL ) to store data.

Steps to manage

To manage databases in cPanel, you can follow these steps.

Firstly, log in to your cPanel account.

Navigate to Tools >> Databases > MySQL Databases.

cPanel Manage Databases

MySQL Databases
MySQL® Database Wizard
Remote MySQL
phpMyAdmin

Database Wizard helps you create new databases and database users and assigns users to databases. The MySQL Database Wizard screen helps with the following tasks:

Create a database
Create a database user
GRANT user privileges

Enter the name and click the Next Step to create a new database.

MySQL Database Wizard

To create a database user.

Enter username and password.

Click on the Create User button.

Create User MySQL cPanel

Add the user to the database.

Select privileges for the user. Select the ‘ALL PRIVILEGES‘ checkbox to grant all the privileges to the user.

cPanel Add User Privileges

Click on the Make Changes button to grant the privileges.

Click on the Next Step button.

phpMyAdmin

Navigate to Databases > phpMyAdmin.

phpMyAdmin provides a web interface to manage MySQL databases, run queries, and perform database operations.

cPanel Manage Databases