Nidhoggur1993 opened a new issue #15481: URL: https://github.com/apache/airflow/issues/15481
Hi there, Mysql 8 seems have changed it's default password plugin from `native` to `caching_sha2_password` ([refer](https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password)). So by default mysql 8 will add user using `caching_sha2_password` like this.  This cause the problem when I try `airflow db init`, it returns this an error (I'll put it in reply). For now I can just use `ALTER USER user IDENTIFIED WITH mysql_native_password BY 'password';` and add this line in `mysqld.cnf` ``` [mysqld] default_authentication_plugin=mysql_native_password ``` to solve the problem. I know it's possible to connect from python using ``` sql = mysql.connector.connect(user='user', password='password', host='ip', database='db', auth_plugin='mysql_native_password') ``` to connection mysql 8 , but I'm wonder if there is or will be some config in `airflow.cfg` that I can change to support airflow connect with caching_sha2_password ? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
