# Creating a new Postgres User, Database

# Creating Postgres User, Database easy way

```plaintext
1.  sudo su postgres 
2.  psql
3.  CREATE DATABASE database_name;
4.  CREATE USER my_username WITH PASSWORD 'my_password';
5.  GRANT ALL PRIVILEGES ON DATABASE "database_name" to my_username;
```

Note: on mac you can `psql postgres` to enter postgres shell

Note: If you get error \`ERROR: permission denied for schema public\` on PG>=15 then do

```plaintext
# connect to the newly created database first and then apply grant

\c database_name
GRANT ALL ON SCHEMA public TO my_username;
```