This guide shows you how to create a new PostgreSQL database user in cPanel and grant it access to an existing database. You'll use the PostgreSQL Databases interface to add the user and assign the necessary permissions.

How to do it

  1. Step 1: Navigate to PostgreSQL Databases

    Log in to cPanel and locate the PostgreSQL Databases interface under the Databases section.

  2. Step 2: Create the new user

    In the Add New User form, enter your desired username and password.

    Important: The username must include your cPanel username as a prefix (e.g., cpaneluser_dbuser).

  3. Step 3: Add the user to a database

    Scroll down to the Add User to Database form. Select the database and the user you just created from the dropdown menus, then click Submit.

  4. Step 4: Set privileges

    After clicking Submit, you'll be redirected to the privileges page. Select the appropriate permissions for the user (typically ALL PRIVILEGES for full access), then click Make Changes.