# How to create new database and new user with password on PostgreSQL (the easiest way)

First, create db:
```
$ createdb avocado
```

Then, create user:
```
$ createuser avocado
```

Then, login to psql with admin user (usually `postgres`) and change password of new user:
```
$ sudo -u postgres psql
psql (9.6.2, server 9.4.4)
Type "help" for help.

postgres=# \password avocado
Enter new password:
Enter it again:
postgres=# \q
```