airflow_set_password.py

import airflow
import getpass
import logging
from airflow import models, settings
from airflow.contrib.auth.backends.password_auth import PasswordUser


def set_password(name, password):
    session = settings.Session()
    u = session.query(PasswordUser).filter_by(username=name).first()
    u.password = password
    session.add(u)
    session.commit()
    session.close()

if __name__ == "__main__":
    logging.basicConfig()
    logging.getLogger('sqlalchemy.engine').setLevel(logging.INFO)

    set_password("johndoe", getpass.getpass())