cPanel 94.0.4 web-hosting control panel
Databases: Create PostgreSQL User
Overview
There are two primary steps when creating a PostgreSQL user. The first step is to create a username and password combination for the user. The second step is to add the user to the database you want the user to access.
Steps
- In the "New User" section, enter the username and password you want to use for this database in the "Username" and "Password" text boxes, respectively.
- Next, click on the Create User button.
- You should see the following statement:
- "Added USERNAME with the password PASSWORD."
- Click on the Go Back link.
- Find the "Add User To Database" section. Select the user you created in Step 6 above from the "User" drop down menu. Then select the database you want to add the user to from the "Database" drop down menu.
- Next, click on the Submit button.
- You should see the following statement:
- "User USERNAME was added to the database DATABASE."
- Click on the Go Back link.
- You should now see the user you created in Step 1 above in the "Users" column.
