Skip to main content

Create Databases and Users

Create DBs and Users

PostgreSQL

Run the following script, which builds the four databases and specifies the appropriate roles (users) for each database, based on the parameters you have specified in trifacta-conf.json and in the pg_hba.conf:

Note

This script must be run as the root user or via sudo superuser.

/opt/trifacta/bin/setup-utils/db/trifacta-create-postgres-roles-dbs.sh

MySQL

Run the following script, which builds the four databases and specifies the appropriate roles (users) for each database, based on the parameters you have specified in trifacta-conf.json:

Note

This script must be run as the root user or via sudo superuser.

/opt/trifacta/bin/setup-utils/db/trifacta-create-mysql-users-dbs.sh -u <MySql_admin_username> -w <MySql_admin_password>

where:

  • -u = MySQL admin username, which is usually root.

  • -w = MySQL admin password

Backup

For more information on backup recommendations and commands, see Backup and Recovery in the Admin Guide.

Configure Non-Default Database Connections

If you have used non-default values for the username, password, host, or port value for either database, you must update platform configuration. For more information, see Database Parameter Reference.