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

2 votes241 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
24 votes242 views6 answers
Alter table name sql
SQL
0 vote223 views2 answers
How to type a blank discord messgae
SQL
0 vote249 views1 answer
Date datatype in livesql
SQL
0 vote253 views1 answer
"Hello User Name"
SQL
0 vote233 views1 answer
How to set sql_mode for a query in CI model
SQL
1 vote217 views1 answer
Sql delete all values in a column
SQL
1 vote199 views1 answer
Mysql get last insert id
SQL
0 vote245 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote217 views1 answer
MySql count occurences more than"
SQL