Managing PostgreSQL databases and users Print

Creating a Database User

1. Log in to cPanel.
2. Open the PostgreSQL Databases tool:                                                                                                                                                                
3. Under "Add New User," enter the desired username and password.
4. Click "Create User" to create the database user.

Changing a User's Password

1. Log in to cPanel.
2. Open the PostgreSQL Databases tool.                                                                                                                                                                
3. Under "Current Users," locate the user whose password you want to change.
4. Click "Change Password" and enter the new password.
5. Click "Change Password" to update the user's password.

Renaming a User

1. Log in to cPanel.
2. Open the PostgreSQL Databases tool.                                                                                                                                                                
3. Under "Current Users," locate the user you want to rename.
4. Click "Rename" and enter the new name.
5. Enter the user's password and click "Change Password" to confirm the changes.

Deleting a User

1. Log in to cPanel.
2. Open the PostgreSQL Databases tool.                                                                                                                                                                
3. Under "Current Users," locate the user you want to delete.
4. Click "Delete" and confirm the deletion by clicking "Remove User."

Managing Databases

To create a database:

1. Log in to cPanel.
2. Open the PostgreSQL Databases tool.                                                                                                                                                                   
3. Under "Create New Database," enter the desired database name.
4. Click "Create Database" to create the database.

To add a user to a database:

1. Log in to cPanel.
2. Open the PostgreSQL Databases tool.                                                                                                                                                                
3. Under "Add User to Database," select the user and the database.
4. Click "Submit" to add the user to the database.

To remove a user from a database:

1. Log in to cPanel.
2. Open the PostgreSQL Databases tool.                                                                                                                                                                
3. Under "Current Databases," locate the user you want to remove.
4. Click the trash can icon and confirm the removal by clicking "Delete User from Database."

To delete a database:

1. Log in to cPanel.
2. Open the PostgreSQL Databases tool.                                                                                                                                                                
3. Under "Current Databases," locate the database you want to delete.
4. Click "Delete" and confirm the deletion by clicking "Delete Database."

By following these steps, you can effectively manage PostgreSQL database users and databases using cPanel.