Configuring SAM and Schema Registry Metadata Stores in MySQL
- Launch the MySQL monitor:
mysql -u root -p
- Create the database for Schema Registry and SAM metastore:
create database registry; create database streamline;
- Create Schema Registry and SAM user accounts, replacing the final
IDENTIFIED BY
string with your password:CREATE USER 'registry'@'%' IDENTIFIED BY 'R12$%34qw'; CREATE USER 'streamline'@'%' IDENTIFIED BY 'R12$%34qw';
- 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 ;
- Commit the operation:
commit;