How to – Create a Database in cPanel

Potpourri
  1. Log in to cPanel.
  2. Navigate to the Databases Section.
    Look for the “Databases” section. Within the “Databases” section, search for and click on the “MySQL Databases” option. This tool will allow you to create and manage MySQL databases in cPanel.
  3. Create a New Database.
    Once you are in the “MySQL Databases” tool, you will see a section for creating a new database. You should follow these steps:Assign a Name to the Database: Choose a name for your new database. This name must be unique.

    Create the Database: Click on the “Create Database” button. cPanel will create the database and show you a confirmation that it has been successfully created.


  4. Create a User to the Database.
    Navigate to the MySQL User section, click on “Add New User,” and enter the username that will have access to the database. Similarly, set a secure password and click en “Create User” button.
  5. Assign the user to the database.
    Now assign the user to the database. This allows the user to access and manage the database. To do this, follow these steps:Assign the user to the database: Navigate to the “Add user to Database” section, select the user and the database; this will assign the user to the database.
    Manage the user’s permissions: Assign privileges to the user for the database. We recommend selecting “All Privileges” and clicking the “Make Changes” button. You can specify individual privileges as needed.

That’s it! You have successfully created a database in cPanel and assigned a user to that database. Now you can use this database to store and manage data on your website or application.

Share

Trusted by Our Clients

Tell us about your website needs - we’d like to hear from you!

What's New

Why Your Business Needs a Website Maintenance Plan

Hosting, Expert Support, and Personalized Service from NDIC As businesses grow, their websites need regular updates, reliable security, and consistent… more

How to Reduce Cart Abandonment Rate and Recover Lost Sales

Cart abandonment is a common challenge in eCommerce, with studies showing that up to 70% of online shoppers abandon their… more

Read All