Create a database and database user

Article

Create a database, give it a separate user and choose that user’s access.

  1. Log in to cPanel from your client area. If that link is unavailable, use the panel address in your welcome email. The cPanel dashboard appears after successful sign-in.

    The own demo domain in cPanel, outlined and marked 1.
  2. Open Database Wizard from Tools. The first database setup step appears.

    Database Wizard in Tools, outlined and marked 2.
  3. Enter a name for the new database. The full database name includes the account prefix shown beside the field.

    The new demo database name in Database Wizard, outlined and marked 3.
  4. Choose Next Step. The database-user creation form appears.

  5. Enter a separate database username. The full username includes the account prefix shown on the form.

    The new demo database username, outlined and marked 5.
  6. Enter a strong password for this database user. Keep its value private.

    The database password field, outlined and marked 6. Both password values are obscured.
  7. Repeat the password in the confirmation field. Both password fields should contain the same private value.

  8. Choose Create User. The permissions step appears.

    Create User beneath the private password fields, outlined and marked 8.
  9. Select the permissions that your application requires. This demo selects SELECT, INSERT, UPDATE and DELETE; another application may require different permissions.

    Only the selected demo database permissions, outlined and marked 9.
  10. Choose Make Changes. Wait for the wizard’s completion message.

    Make Changes below the selected permissions, outlined and marked 10.
  11. Choose Return to Manage My Databases. The database management page opens.

    Return to Manage My Databases after the wizard completes, outlined and marked 11.
  12. Find the new database under Current Databases and check that the intended user appears in Privileged Users.

    The own new database and linked user in Current Databases, outlined and marked 12.

Keep the database name, database username and database password with the application that needs them. These are separate from your cPanel sign-in details.

Video walkthrough

Sources

For help, contact Faciotech support.