Installing HDF Services on an Existing HDP Cluster
Also available as:
PDF

Configure SAM and Schema Registry Metadata Stores in MySQL

Steps

  1. Launch the MySQL monitor:

    mysql -u root -p
  2. Create the database for the Registry and SAM metastore:

    create database registry;
    create database streamline;
  3. Create Schema Registry and SAM user accounts, replacing the last string with your password:

    CREATE USER 'registry'@'%' IDENTIFIED BY 'R12$%34qw';
    CREATE USER 'streamline'@'%' IDENTIFIED BY 'R12$%34qw';
    
  4. Assign privileges to the user account:

    GRANT ALL PRIVILEGES ON registry.* TO 'registry'@'%' WITH GRANT OPTION ;
    GRANT ALL PRIVILEGES ON streamline.* TO 'streamline'@'%' WITH GRANT OPTION ;
  5. Commit the operation:

    commit;