play-jwt-starter project.
To setup PostgreSQL database install using
sudo apt install postgresql-9.5
- Create a new user in database
sudo -u postgres createuser playdb
- Run the following query to set password in
psqlconsole
ALTER USER playdb WITH ENCRYPTED PASSWORD '<HERE>';
Note: You can pick up the password from configuration file
application.conf.
- Create the database
CREATE DATABASE playdb;
- Grant database access to newly created user
playdb
GRANT ALL PRIVILEGES ON DATABASE playdb TO playdb;