Creating new database on cpanel

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

Prerequisites:

• You have a cPanel account with a hosting provider.
• You have basic knowledge of databases and SQL.

Step 1: Log in to cPanel

• Go to your website's URL and add /cpanel to the end (e.g., example.com/cpanel).
• Enter your cPanel username and password to log in.

Step 2: Navigate to the Databases section

• In the cPanel dashboard, click on the "Databases" icon, which is usually located in the "MySQL" or "Database" section.

Step 3: Click on the "MySQL Databases" tab

• In the Databases section, click on the "MySQL Databases" tab.

Step 4: Create a new database

• Click on the "Create a New Database" button.
• Enter a name for your database in the "Database Name" field. Make sure it's unique and follows the naming conventions (e.g., mydatabase).
• Click the "Create Database" button.

Step 5: Create a new user

• Click on the "Add a New User" button.
• Enter a username for your database user in the "Username" field. Make sure it's unique and follows the naming conventions (e.g., myuser).
• Enter a strong password for your database user in the "Password" field.
• Confirm the password in the "Password (again)" field.
• Click the "Create User" button.

Step 6: Grant privileges to the user

• Click on the "Add User to Database" button.
• Select the database you created in Step 4 from the "Database" dropdown menu.
• Select the privileges you want to grant to the user (e.g., "ALL PRIVILEGES").
• Click the "Make Changes" button.

Step 7: Verify the database and user

• Go back to the "MySQL Databases" tab and verify that your new database and user have been created successfully.

That's it! You have now created a new database on cPanel. You can use this database to store data for your website or application.