Useradd postgres

Psql create user

# https://www.postgresql.org/docs/8.0/sql-createuser.html
CREATE USER <username> WITH PASSWORD '<password>' VALID UNTIL '<date here>';

Useradd postgres

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

Source: medium.com

Similar codes

0 vote337 views1 answer
How to add more columns to a table in mysql
SQL
2 votes377 views1 answer
Mysql create user with remote access
SQL
34 votes361 views6 answers
Install mysql client ubuntu
SQL
0 vote350 views1 answer
Sql query tags
SQL
2 votes344 views1 answer
SQL IF ELSE
SQL
0 vote349 views2 answers
Nosqlbooster query other collection
SQL
-1 vote322 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
1 vote335 views1 answer
Xampp import sql file command line
SQL
1 vote375 views1 answer
How to see logical reads in sql server
SQL
3 votes320 views2 answers
Oracle for loop
SQL