Knowledgebase

Creating and managing databases

Sure, here's an article for end users on creating and managing databases in Unique Hosting Private Limited's WHMCS portal.

Creating and Managing Databases in Unique Hosting Private Limited's WHMCS Portal

Databases are an integral part of any website or web application. They store information and help in organizing and retrieving data. In Unique Hosting Private Limited's WHMCS portal, you can create and manage databases easily. Here's a step-by-step guide to help you get started.

Creating a Database

  1. Login to your Unique Hosting Private Limited WHMCS portal at https://uniquehosting.com/cp/.
  2. Click on the "Databases" option in the top menu.
  3. Click on the "Create Database" button.
  4. Enter a name for your database.
  5. Choose the database type (MySQL or PostgreSQL).
  6. Enter a username and password for the database.
  7. Click on the "Create" button.

Your database is now created, and you can start using it.

Managing Databases

Once you have created a database, you can manage it using the following steps.

  1. Login to your Unique Hosting Private Limited WHMCS portal at https://uniquehosting.com/cp/.
  2. Click on the "Databases" option in the top menu.
  3. Locate the database you want to manage and click on the "Manage" button.
  4. You can now perform various tasks such as creating tables, importing data, exporting data, and managing users.

Creating Tables

To create a table in your database, follow these steps.

  1. Click on the "Manage" button for the database you want to create a table in.
  2. Click on the "Create Table" button.
  3. Enter a name for the table and the number of columns you want to create.
  4. Add the column names and data types.
  5. Click on the "Create" button.

Your table is now created, and you can start adding data to it.

Importing Data

To import data to your database, follow these steps.

  1. Click on the "Manage" button for the database you want to import data to.
  2. Click on the "Import" button.
  3. Select the file you want to import.
  4. Choose the options for the import.
  5. Click on the "Import" button.

Your data is now imported to your database.

Exporting Data

To export data from your database, follow these steps.

  1. Click on the "Manage" button for the database you want to export data from.
  2. Click on the "Export" button.
  3. Choose the options for the export.
  4. Click on the "Export" button.

Your data is now exported from your database.

Managing Users

To manage users in your database, follow these steps.

  1. Click on the "Manage" button for the database you want to manage users for.
  2. Click on the "Users" tab.
  3. Click on the "Create User" button.
  4. Enter a username and password for the user.
  5. Choose the privileges for the user.
  6. Click on the "Create" button.

Was this answer helpful?

0 Users Found This Useful