How to create new database in phpmyadmin in cpanel

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

Prerequisites:

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

Step-by-Step Instructions:

  1. Log in to your cPanel account and navigate to the "Databases" section.
  2. Click on the "phpMyAdmin" icon.
  3. You will be redirected to the phpMyAdmin login page. Enter your cPanel username and password to log in.
  4. Once logged in, you will see a list of databases on the left-hand side of the page.
  5. Click on the "Databases" tab at the top of the page.
  6. Click on the "Create a new database" button.
  7. Enter a name for your new database in the "Database name" field. Make sure it is unique and follows the naming conventions (e.g., mydatabase).
  8. Choose a collation for your database from the dropdown menu. The default collation is usually sufficient.
  9. Click on the "Create" button to create the new database.

Verify the Database Creation:

  1. Once the database is created, you will see it listed on the left-hand side of the page.
  2. Click on the database name to view its contents.
  3. You should see an empty database with no tables or data.

Create a User and Grant Privileges:

  1. To access your new database, you need to create a user and grant them privileges.
  2. Click on the "Users" tab at the top of the page.
  3. Click on the "Create a user" button.
  4. Enter a username and password for the new user.
  5. Choose the privileges you want to grant to the user. For a new database, you can start with the "db" privilege, which allows the user to create, modify, and delete tables.
  6. Click on the "Go" button to create the new user.

Access Your New Database:

  1. Now you can access your new database using phpMyAdmin.
  2. Click on the database name to view its contents.
  3. You can create tables, insert data, and perform other database operations using the phpMyAdmin interface.

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