1sudo -u postgres psql
2postgres=# create database mydb;
3postgres=# create user myuser with encrypted password 'mypass';
4postgres=# grant all privileges on database mydb to myuser;
1CREATE DATABASE yourdbname;CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass';GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;
1CREATE USER visualscrapy WITH PASSWORD '123456';
2# it will create the new user in postgres