Skip to content

How to Create, Manage, and Delete a MySQL Database in Cpanel

Netspace offers an easy-to-use web hosting platform called Cpanel that allows you to create, manage, and delete a MySQL database with just a few clicks. Whether you are a beginner or an experienced user, this article will guide you through the process of creating a database, adding a user, and deleting the database if needed.

Prerequisites #

Before you start, you will need to have a Linux-shared hosting account with Netspace and access to the cPanel. If you do not have a Netspace account from bellow links:

Linux Hosting

Linux Reseller Hosting

Step 1: Log in to cPanel #

To log in to the cPanel, go to the Netspace website and click on the "cPanel Login" button from your service area or visit www.yourdomain.com/cpanel
Username / password is provided in your account activation email.

Step 2: Create a MySQL Database #

In the cPanel dashboard, scroll down to the "Databases" section and click on "MySQL Databases."

create mysql database

In the "Create New Database" section, enter a name for your database and click on the "Create Database" button.
A new database will be created with the name you entered.

create new mysql database

Step 3: Add a User to the Database #

In the "MySQL Databases" section, scroll down to the "Add New User" section. Enter a username and password for the user and click on the "Create User" button.

After the user is created, you will need to add the user to the database. To do this, scroll down to the "Add User to Database" section and select the user and database from the drop-down menus. Click on the "Add" button to add the user to the database.

add user to mysql db cpanel

Step 4: Manage Database and User Permissions #

In the "MySQL Databases" section, you can manage the permissions for the database and user. To do this, scroll down to the "Manage User Privileges" section and select the user and database from the drop-down menus.

In the "Privilege" section, you can choose the specific privileges you want to grant to the user, such as "SELECT," "INSERT," "UPDATE," and "DELETE." When you are finished, click on the "Make Changes" button to apply the changes.

Step 5: Delete a Database and User #

If you no longer need a database or user, you can delete them in the cPanel. To delete a database, go to the "MySQL Databases" section and scroll down to the "Current Databases" section. Select the database you want to delete and click on the "Delete Database" button.

To delete a user, go to the "MySQL Databases" section and scroll down to the "Manage User Privileges" section. Select the user you want to delete and click on the "Revoke Privileges" button.

dalete mysql cpanel user

Creating, managing, and deleting a MySQL database and user in Netspace, Cpanel is simple and straightforward. With these easy-to-follow steps, you can quickly create and manage a database for your website. If you have any questions or need further assistance, you can contact HostGator support for help.

What are your feelings
Updated on February 9, 2023
//
Our customer sales team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?