Manual Schema Creation (DBA Step)

About this task

Create the MariaDB users and schemas before you trigger the DDL execution DAG.

Procedure

  1. Log in to MariaDB with the DBA account.
  2. Navigate to ddls/mariadb_ddls/ in the extracted CDM package.
  3. Open Step1_user_schema_creation_mariadb.sql and replace every instance of <password> with a secure password.
  4. Run Step1_user_schema_creation_mariadb.sql.
  5. Run Step1a_grant_roles_privileges_mariadb.sql.

What to do next

Note:
These two scripts are not part of the DAG step list. The DBA must run them before the DAG runs.