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

WooCommerce Analytics 101: Turning Data into Profits

Running a successful WooCommerce store requires more than just a great product and an appealing website. To truly thrive in… more

5 Quick Holiday Marketing Strategies You Can Implement TODAY

The holiday season is fast approaching, and it’s not too late to prepare your business for the busiest time of… more

Read All