CREATE DATABASE sample_db;

CREATE USER sample_user WITH PASSWORD 'password';
GRANT ALL PRIVILEGES ON DATABASE sample_db TO sample_user;

Enter with
psql -U sample_user -d sample_db