Create-Database-cPanel

Creating a database

  1. Log into cPanel.
  2. Under the “Databases”, click “MySQL databases”.
  3. In the “Create database” field, type the name of your new database.
  4. Click “Create database”.

Create-User-cPanel-2

Creating a user

  1. Log into cPanel
  2. Under the “Databases”, click “MySQL databases”.
  3. Click “Jump to MySQL users”.
  4. Find a set of fields called “Add a New User”.
  5. Enter a username in the corresponding field and password into both “Password” and “Password (confirm)”.
  6. Click “Create User”.

Giving access to the 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 to access. Click “Add”.
  5. From the “MySQL Account Maintenance” screen, select the privileges you wish to grant the user, or select ALL PRIVILEGES.
  6. Click “Make changes”.