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:
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."
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.
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.
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.
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.
