# Create PostgreSQL Role and Database

### Creating PostgreSQL Role and Database

The <mark style="color:orange;">`createuser`</mark> command allows you to create new roles from the command line. Only superusers and roles with <mark style="color:orange;">`CREATEROLE`</mark> privilege can create new roles.

In the following example, we’ll create a new role named <mark style="color:orange;">`kylo`</mark>, a database named <mark style="color:orange;">`kylodb`</mark> and grant privileges on the database to the role.

1. Connect to the database:

```bash
sudo su - postgres
psql
```

1. Create the USER by issuing the following command:

```sql
CREATE USER Kylo with password 'PASSWORD123';
```

1. Create Database:

```sql
CREATE DATABASE kylodb; 
```

1. Grant Permissions to the database

```sql
GRANT ALL PRIVILEGES ON DATABASE kylodb TO kylo;
```