How do I create a database?

This process actually involves three steps:
  1. Creating a database
  2. Creating a database user
  3. Giving your database user access to work with your database

Creating a database

  1. Log into cPanel.
  2. Under Databases, click MySQL Databases.
  3. In the New Database field, enter a name for the database.
  4. Click Create Database.

That's it.

Creating 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.
  5. Enter a password in the Password field.
    • For help generating a strong password, click the Generate Password button.
  6. Retype the password in the Password (Again) field.
  7. Click Create User.
That's it.

Giving your database user access to work with your database

  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.
That's it and you're done!
  • Email, SSL
  • 0 Users Found This Useful
Was this answer helpful?