Configure Your Database for Oozie
For Derby:
No database configuration is required.
For MySQL:
echo "create database if not exists oozie;" | mysql -u root echo "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`'