Creating a new database in fastcomet server

Here's a step-by-step guide on how to create a new database in FastComet server:

Prerequisites:

  1. You have a FastComet account and have logged in to the control panel.
  2. You have a domain name or a subdomain that you want to use for your database.

Step 1: Access the Database Manager

  1. Log in to your FastComet control panel.
  2. Click on the "Databases" tab from the top menu.
  3. Click on the "Create Database" button.

Step 2: Fill in the Database Details

  1. Enter a name for your database in the "Database Name" field. This will be the name of your database, and it should be unique.
  2. Choose a database type from the dropdown menu. FastComet supports MySQL, PostgreSQL, and MariaDB.
  3. Select the database engine version from the dropdown menu. For example, MySQL 8.0 or PostgreSQL 12.
  4. Choose the database storage type. You can choose between InnoDB, MyISAM, or General Table Storage.
  5. Set the database collation. This determines the character set and collation of your database.
  6. Set the database character set. This determines the character set used in your database.
  7. Click the "Create Database" button to create the database.

Step 3: Set Up the Database User

  1. Click on the "Users" tab from the top menu.
  2. Click on the "Create User" button.
  3. Enter a username and password for the database user.
  4. Choose the database privileges for the user. You can choose from a range of privileges, including SELECT, INSERT, UPDATE, DELETE, and GRANT.
  5. Click the "Create User" button to create the database user.

Step 4: Grant Privileges to the Database User

  1. Click on the "Privileges" tab from the top menu.
  2. Click on the "Grant Privileges" button.
  3. Select the database user you created in Step 3.
  4. Choose the privileges you want to grant to the user. You can choose from a range of privileges, including SELECT, INSERT, UPDATE, DELETE, and GRANT.
  5. Click the "Grant Privileges" button to grant the privileges to the user.

Step 5: Connect to the Database

  1. Use a database management tool such as phpMyAdmin or a MySQL client to connect to your database.
  2. Enter the database hostname, username, password, and database name to connect to your database.

That's it! You have now created a new database in FastComet server.