This is an automated email from the ASF dual-hosted git repository. ephraimanierobi pushed a commit to branch v2-3-test in repository https://gitbox.apache.org/repos/asf/airflow.git
commit 481877a564992b536b1728a40b726f4e83983191 Author: Nigel Millward <[email protected]> AuthorDate: Sat Jul 9 19:05:17 2022 +0100 Fix syntax in mysql setup documentation (#24893 (#24939) In the 'set-up-databases' documentation the code block was not working on newer versions of mssql. Updated the docs so that the query works on supported 2017 and 2019 versions of mssql (cherry picked from commit 335bd60cb3b0cc16aa7c9a9ace83073ae7d9e82c) --- docs/apache-airflow/howto/set-up-database.rst | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/docs/apache-airflow/howto/set-up-database.rst b/docs/apache-airflow/howto/set-up-database.rst index cdf9f04ace..15a3d10c43 100644 --- a/docs/apache-airflow/howto/set-up-database.rst +++ b/docs/apache-airflow/howto/set-up-database.rst @@ -325,7 +325,7 @@ You can read more about transaction isolation and snapshot features at CREATE LOGIN airflow_user WITH PASSWORD='airflow_pass123%'; USE airflow; CREATE USER airflow_user FROM LOGIN airflow_user; - GRANT ALL PRIVILEGES ON DATABASE airflow TO airflow_user; + GRANT ALL PRIVILEGES ON DATABASE::airflow TO airflow_user; We recommend using the ``mssql+pyodbc`` driver and specifying it in your SqlAlchemy connection string.
