This is an automated email from the ASF dual-hosted git repository. potiuk pushed a commit to branch v2-2-test in repository https://gitbox.apache.org/repos/asf/airflow.git
commit 8ecdcb9c2f8167d997d123a1aebc1d19de1e2ccb Author: Richard Pelgrim <[email protected]> AuthorDate: Wed Dec 8 12:27:58 2021 +0100 Fix typo in MySQL Database creation code (Set up DB docs) (#20102) * Fix typo in MySQL Database creation code Character set `utf8` is an alias for `utf8mb3`, see docs linked below. This means collation should be set to `utf8mb3_unicode_ci`. Using `COLLATE utf8mb4_unicode_ci` (current code) throws the following error: `ERROR 1253 (42000): COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8'` (cherry picked from commit 9347832633a41b7b1e759d32ee756e7987f14a0d) --- 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 f2f7fb6..14051b3 100644 --- a/docs/apache-airflow/howto/set-up-database.rst +++ b/docs/apache-airflow/howto/set-up-database.rst @@ -238,7 +238,7 @@ In the example below, a database ``airflow_db`` and user with username ``airflo .. code-block:: sql - CREATE DATABASE airflow_db CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci; + CREATE DATABASE airflow_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; CREATE USER 'airflow_user' IDENTIFIED BY 'airflow_pass'; GRANT ALL PRIVILEGES ON airflow_db.* TO 'airflow_user';
