Creating user, database and adding access on PostgreSQL

PHOTO EMBED

Thu Mar 10 2022 03:28:53 GMT+0000 (UTC)

Saved by @arifin21 #postgres

sudo -u postgres psql
create database mydb;
create user myuser with encrypted password 'mypass';
grant all privileges on database mydb to myuser;
content_copyCOPY

https://medium.com/coding-blocks/creating-user-database-and-adding-access-on-postgresql-8bfcd2f4a91e