Cloudera Docs

Configure your SMM database

You can use the following databases with SMM:

  • Postgres
  • MySQL
  • Oracle
  • MariaDB
  1. To configure a MySQL database: 
    create database streamsmsgmgr;
CREATE USER 'streamsmsgmgr'@'localhost' IDENTIFIED BY 'streamsmsgmgr';
GRANT ALL PRIVILEGES ON streamsmsgmgr.* TO 'streamsmsgmgr'@'localhost' WITH GRANT OPTION;
CREATE USER 'streamsmsgmgr'@'%' IDENTIFIED BY 'streamsmsgmgr';
GRANT ALL PRIVILEGES ON streamsmsgmgr.* TO 'streamsmsgmgr'@'%' WITH GRANT OPTION;
  2. To configure a Postgres database: 
    # Log in database
sudo su postgres
psql

# Setup databases and users
create database streamsmsgmgr;
CREATE USER streamsmsgmgr WITH PASSWORD streamsmsgmgr;
GRANT ALL PRIVILEGES ON DATABASE "streamsmsgmgr" to streamsmsgmgr;