4. Configure Your Database for Oozie

For Derby:

No database configuration is required.

For MySQL:

echo "create database if not exists oozie;" | mysql -u rootecho "grant all privileges on oozie.* to 'oozie'@'localhost' identified by 'oozie';" | mysql -u root echo "grant all privileges on oozie.* to 'oozie'@`hostname -f` identified by 'oozie';" | mysql -u root

For PostgreSQL:

psql -U postgres -c "CREATE DATABASE oozie;" | psql -U postgres -c "CREATE USER oozie WITH PASSWORD 'oozie';" | psql -U postgres -c "GRANT ALL PRIVILEGES ON DATABASE oozie TO oozie;"

For Oracle:

bash -l -c 'echo "create user oozie identified by oozie;" | sqlplus system/root@`hostname -f`' bash -l -c 'echo "GRANT SELECT_CATALOG_ROLE TO oozie;" | sqlplus system/ root@`hostname -f`' bash -l -c 'echo "GRANT CONNECT, RESOURCE TO oozie;" | sqlplus system/ root@`hostname -f`'