Configuring Druid and Superset Metadata Stores in MySQL
About This Task
Druid and Superset require a relational data store to store metadata. To use MySQL for this, install MySQL and create a database for the Druid metastore.
Steps
Launch the MySQL monitor:
mysql -u root -p
Create the database for the Druid and Superset metastore:
CREATE DATABASE druid DEFAULT CHARACTER SET utf8; CREATE DATABASE superset DEFAULT CHARACTER SET utf8;
Create
druid
andsuperset
user accounts, replacing the finalIDENTIFIED BY
string with your password:CREATE USER 'druid'@'%' IDENTIFIED BY '9oNio)ex1ndL'; CREATE USER 'superset'@'%' IDENTIFIED BY '9oNio)ex1ndL';
Assign privileges to the
druid
account:GRANT ALL PRIVILEGES ON *.* TO 'druid'@'%' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'superset'@'%' WITH GRANT OPTION;
Commit the operation:
commit;