PostgreSQL

sudo -u postgres psql

PostgreSQL

create user bp1step with password 'password';
\du
grant all privileges on DATABASE bp1step TO bp1step;
create database bp1step owner bp1step;
\l