Hortonwork HDP default password

Hadoop.HDP.DefaultPassword

Ambari Metastore default database configuration

WARNING: Before starting Ambari Server, you must run the following DDL against the database to create the schema: /var/lib/ambari-server/resources/Ambari-DDL-Postgres-CREATE.sql

Psql

create user ambari with password 'bigdata';

create database ambari owner ambari;

grant all privileges on database ambari to ambari;

\list

\connect ambari

alter database ambari owner to ambari;

psql -U ambari -d ambari -f /var/lib/ambari-server/resources/Ambari-DDL-Postgres-CREATE.sql