airflow: Documentation is missing instructions for preparing database for Airflow (during installation)

Apache Airflow version: 1.10.11

Kubernetes version (if you are using kubernetes) (use kubectl version): N/A

Environment:

• Cloud provider or hardware configuration: AWS
• OS (e.g. from /etc/os-release): Amazon Linux 2
• Kernel (e.g. uname -a): N/A
• Install tools: N/A
• Others: N/A

What happened: Airflow documentation is missing a step – preparing the database for Airflow initdb.

This includes creating the “airflow” database, and the “airflow” user.

There are multiple different instructions for it outside the documentation, e.g.:

https://medium.com/@srivathsankr7/apache-airflow-a-practical-guide-5164ff19d18b says:

mysql -u root -p
mysql> CREATE DATABASE airflow CHARACTER SET utf8 COLLATE utf8_unicode_ci;
mysql> create user 'airflow'@'localhost' identified by 'airflow';
mysql> grant all privileges on * . * to 'airflow'@'localhost';
mysql> flush privileges;

http://site.clairvoyantsoft.com/installing-and-configuring-apache-airflow/ says:

CREATE DATABASE airflow CHARACTER SET utf8 COLLATE utf8_unicode_ci;
grant all on airflow.* TO ‘USERNAME'@'%' IDENTIFIED BY ‘{password}';

https://airflow-tutorial.readthedocs.io/en/latest/first-airflow.html says:

MySQL -u root -p
mysql> CREATE DATABASE airflow CHARACTER SET utf8 COLLATE utf8_unicode_ci;
mysql> GRANT ALL PRIVILEGES ON airflow.* To 'airflow'@'localhost';
mysql> FLUSH PRIVILEGES;

(This last one seems to be missing the step of creating the airflow user.)

What you expected to happen:

I would expect https://airflow.apache.org/docs/stable/howto/initialize-database.html to contain complete instructions for preparing the database backend for initialization.

How to reproduce it:

Try to install Airflow with a MySQL backend with no prior knowledge by following the Airflow documentation.

Anything else we need to know:

Airflow rocks!