Postgresql

Create/Alter new user:

su – postgres
psql
alter user postgres with password ‘newpassword’; OR ALTER USER username ENCRYPTED password ‘newpassword’;


Create database:
create database databaseName;
create database databaseName with encoding ‘SQL_ASCII’; OR create database databaseName with encoding ‘utf8′;
grant all privileges on database databaseName to username;