# createuser mypguser
# createdb -O mypguser mypgdatabase

or by connecting to postgresql server using psql – posgresql cli connect client equivalent of
“mysql” command line interface:

# su – postgres

$ psql

postgres=# CREATE USER mypguser WITH PASSWORD ‘mypguserpass’;
postgres=# CREATE DATABASE mypgdatabase OWNER mypguser;