How to create database in cPanel?

  1. Log into cPanel.
  2. Under Databases, click MySQL Databases.
  3. In the New Database field, type a name for the database.
  4. Click Create Database.
  5. Click Go Back.
  6. The new database will appear in the Current Databases table

Create a Database User

After creating the database, you will need to create a user and assign privileges. Please note that MySQL user accounts must be created separately from mail and web administrator accounts.

Create a Database User

  1. Log into cPanel.
  2. Under Databases, click MySQL Databases.
  3. Click Jump to MySQL Users in the top-right corner of the page.
  4. Under Add New User, enter a username. Be sure that the username is 7 letters or shorter.
  5. Enter a password in the Password field.
  6. For help generating a strong password, click the Generate Passwordbutton.
  7. Retype the password in the Password (Again) field.
  8. Click Create User.

Assign Privileges to Database User

  1. Log into cPanel.
  2. Under Databases, click MySQL Databases.
  3. Under Add User to Database, select a user from the User drop-down menu.
  4. From the Database drop-down menu, select the database to which you wish to allow the user access.
  5. Click Add.
  6. From the MySQL Account Maintenance screen, select the privileges you wish to grant the user, or select ALL PRIVILEGES.
  7. Click Make Changes.
  • 20 Users Found This Useful
Was this answer helpful?

Related Articles

Working with SQL databases

In order for your MySQL database to work as intended, it will need a script calling or querying...

What is Parked domain?

A parked or Alias domain is a domain that you add to your cPanel account and that domain...

How to create a subdomain in cPanel?

In the latest versions of cPanel, the process of adding a subdomain is similar, but the interface...

What is Addon domain?

An addon domain is a fully functional domain that can be created from within your control panel....

How to Log into cPanel

cPanel Access You can access your cPanel in any of the following ways: Option 1: If you are...