Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save dbist/f6b5e24641f5b57b133d2beb20ae44f0 to your computer and use it in GitHub Desktop.
Save dbist/f6b5e24641f5b57b133d2beb20ae44f0 to your computer and use it in GitHub Desktop.
Create MySQL users for Streaming Analytics Manager and Schema Registry
CREATE DATABASE streamline;
CREATE USER 'streamline'@'%';
GRANT ALL PRIVILEGES ON streamline.* to 'streamline'@'%' WITH GRANT OPTION;
SET PASSWORD FOR 'registry'@'%' = PASSWORD('R12$%34qw');
FLUSH PRIVILEGES;
CREATE DATABASE registry;
CREATE USER 'registry'@'%';
GRANT ALL PRIVILEGES ON registry.* to 'registry'@'%' WITH GRANT OPTION;
SET PASSWORD FOR 'registry'@'%' = PASSWORD('R12$%34qw');
FLUSH PRIVILEGES;
# make sure password R12$%34qw is stored in Ambari UI for both services
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment