<h1 id="heading-creating-postgres-user-database-easy-way">Creating Postgres User, Database easy way</h1>
<pre><code>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;
</code></pre>Note: on mac you can <code>psql postgres</code> to enter postgres shell

# Creating Postgres User, Database easy way


```
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


Shrawan's Blog

Shrawan's Blog

Creating a new Postgres User, Database

Creating Postgres User, Database easy way