Dylan0203/text.md

Created September 6, 2017 15:31

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Dylan0203/e6db3e61dd9b4f792d0ea28705d4d244.js"></script>
Save Dylan0203/e6db3e61dd9b4f792d0ea28705d4d244 to your computer and use it in GitHub Desktop.

PostgreSQL add or create a user account and grant permission for database

Raw

$ sudo -u postgres psql

Create User

$ sudo -u postgres createuser <username>

Creating Database

$ sudo -u postgres createdb <dbname>

Giving the user a password

$ sudo -u postgres psql
psql=# alter user <username> with encrypted password '<password>';

Granting privileges on database

psql=# grant all privileges on database <dbname> to <username> ;

Select an option