Airflow Database for MYSQL is not created as per the standard

[akash-jain-10]

Affected module Does it impact the UI, backend or Ingestion Framework? Docker.

Describe the bug openmetadata/db is responsible to create airflow database and its users when running through docker installation. As per the Airflow Docs recommendation here, we need to create database airflow_db with proper character set and collate.

Things to update as part of this issue - https://github.com/open-metadata/OpenMetadata/blob/0b0d1c51d92f004ca67e81db0d0cb01a81a4d728/docker/local-metadata/mysql-script.sql#L2

this needs to be updated as CREATE DATABASE airflow_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Second part is to update Helm Charts with the above database creation script which can be found here