Creating a new databse in phpmyadmin on cpanel

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

Prerequisites:

  1. You have a cPanel account and have logged in to it.
  2. You have PHPMyAdmin installed and configured on your cPanel account.

Step 1: Access PHPMyAdmin

  1. Log in to your cPanel account.
  2. Click on the "Databases" tab.
  3. Click on the "MySQL Databases" icon.
  4. Click on the "phpMyAdmin" icon.

Step 2: Create a New Database

  1. In the PHPMyAdmin interface, click on the "Databases" tab.
  2. Click on the "Create a new database" button.
  3. Enter a name for your database in the "Database name" field. Make sure it's unique and follows the naming conventions (e.g., mydatabase).
  4. Choose a collation for your database. The default collation is usually sufficient.
  5. Click the "Create" button to create the database.

Step 3: Set Up Database Privileges

  1. Once the database is created, you'll be taken to the database's main page.
  2. Click on the "Privileges" tab.
  3. Click on the "Add a new user" button.
  4. Enter a username and password for the database user. Make sure to choose a strong password.
  5. Assign the user to the database by selecting the database name from the dropdown menu.
  6. Choose the privileges you want to grant to the user. The default privileges are usually sufficient.
  7. Click the "Go" button to save the changes.

Step 4: Verify the Database

  1. Go back to the database's main page.
  2. Verify that the database has been created and the user has been added.
  3. You can now start creating tables, inserting data, and managing your database using PHPMyAdmin.

That's it! You have successfully created a new database in PHPMyAdmin on cPanel.