logo
logo
Account menu

Databases

About how to Create, Edit, Delete Database, or Database Username in cPanel.

How to Create a Database in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on MySQL Databases. 3. In the New Database field, enter a name for the new database you wish to create.4. Click on Create Database.

How to Rename a Database in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3. Under Current Databases, you can see a list of all your databases. Locate the Database and then click on Rename.4. Change the da...

How to Delete a Database in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases.  3. Under Current Databases, you can see a list of all your databases. Locate the database you want to remove and click on Delete.4...

How to Create a Database Username in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3. Under MySQL Users, in the Username field, enter the new username you want to create. 4. Enter your new password or use a passwor...

How to Add a User to a Database and Grant Privileges

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3. Scroll down to the end of the page and under Add User to Database. Select a user from the drop-down list, and choose a Database...

How to Import a Database via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin.3. From the navigation tree in the left sidebar, select an appropriate database in which you want to import data using the SQL file. 4. Cl...

How to Export Database Table via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin. 3. From the navigation tree in the left sidebar. Please select an appropriate database that you want to export to your computer 4. Click...

How to Edit a Database Table via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin.3. Click on the Expand icon from the navigation tree in the left sidebar. 4. Select the appropriate table you want to edit. If you wish to...

How to Delete a Database Table via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin. 3. Click on the Expand icon from the navigation tree in the left sidebar. 4. Select the appropriate table you want to delete. If you're g...

How to Optimize a Database via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin. 3. Click on the Expand icon from the navigation tree in the left sidebar. 4. Scroll down and mark Check All. Click on the drop-down optio...

How to Repair a Database via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin.3. Click the Expand icon from the navigation tree in the left sidebar. 4. Scroll down and mark Check All. Then click on the drop-down arro...