Databases offer a method for managing large amounts of information easily over the web. They are necessary to run many web-based applications such as bulletin boards, content management systems, and online retail shops. After reading this document, you will be able to create and manage databases within cPanel. We have divided the database management in cPanel into the following five sections:

1)    Creating New Databases

2)    Managing Database Users

3)    Searching Databases

4)    Database Troubleshooting

5)    Deleting a Database

CREATING NEW DATABASES

Follow the steps below to create a new database.

1)    Login to your cPanel account at HTTPS://IPADDRESS:2082.

2)    Click on MySQL® Databases in the Databases section.

 

download__31_.png

3)    In the New Database field, type a name for the database.

4)    Click Create Database.

3)    Click Go Back. The new database will appear in the Current Databases table.

 

download__32_.png

MANAGING DATABASE USERS

After you create the database, you will need to create database users and perhaps manage their privileges so that they can access and manage the database. To create a new user account, please follow the steps below:

CREATE A DATABASE USER

1)    Login to cPanel and click on MySQL® Databases in the Databases section.

 

download__33_.png

2)    In the Add User To Database section, please select a user from the User drop-down menu.

3)    From the Database drop-down menu, please select the database to which you wish to allow the user access.

 

download__34_.png

4)    Click Add.

5)    On the MySQL Account Maintenance screen, please select the privileges you wish to grant the user, or select ALL PRIVILEGES.

 

download__36_.png

6)    Click Make Changes.

Modify a User's Privileges

If your user’s privileges have already been defined and now you need to change what that user has access to, follow these steps to modify a user’s privileges:

1)    Login to cPanel and click on MySQL® Databases in the Databases Section.

 

download__37_.png

2)    Click the user’s name in the Current Databases list

 

download__38_.png

3)    If you are sure you want to remove the user’s privileges to manage the database, click Delete User from Database.

 

download__39_.png

SEARCHING DATABASES

The current databases table contains a list of databases on your server. For each database, the table displays the following:

  • The name of the database.
  • The size of the database.
  • Users who may manipulate the database.
  • A link allowing you to delete the database.

 

download__40_.png

To search the Current Databases table, follow the steps below:

1)    Login to cPanel and click on MySQL® Databases in the Databases section.

 

download__41_.png

2)    Type your criteria in the Search field.

 

download__42_.png

3)    Click Go.

 

The table will display the search results.

DATABASE TROUBLESHOOTING

If you are experiencing problems using any database-related software you have installed on the server, you should check your databases for errors and run a repair on the database.

CHECKING A DATABASE FOR ERRORS

To check a database, please follow the steps below:

1)    Login to cPanel and click on MySQL® Databases in the Databases section.

 

download__43_.png

2)    In the Check DB drop-down menu, select the database you wish to check.

3)    Click Check DB.

 

download__44_.png

cPanel will run a script that attempts to automatically repair the database.

DELETING A DATABASE

Follow these steps to delete a database from the server:

1)    Login to cPanel and click on MySQL® Databases in the Databases section.

 

download__45_.png

2)    Locate the database you wish to delete in the Current Databases table.

3)    Click Delete Database next to the database you wish to delete.

 

download__46_.png

4)    If you are sure you want to permanently delete the database, click Yes.

 

download__47_.png

You should now be familiar with the most important aspects of creating and managing databases within your cPanel server.