[jira] [Commented] (AIRFLOW-4051) MySQL hook bulk_load function doesn't work by default with MySql 8

["jack (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AIRFLOW-4051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823817#comment-16823817 ] 

jack commented on AIRFLOW-4051:
-------------------------------

Is this really an Airflow issue?

It's not a bug in the hook nor a bug in the mysql lib - This is the expected behavior.

It's not different then trying to execute command and have it fails due to lack of permissions. Fix the permissions than the execution will be successful. 

Also, no given work-around was suggested in the docs.

The only solution for users who still want to use it is to lower their security settings to allow such risky transfer. 

> MySQL hook bulk_load function doesn't work by default with MySql 8
> ------------------------------------------------------------------
>
>                 Key: AIRFLOW-4051
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-4051
>             Project: Apache Airflow
>          Issue Type: Improvement
>          Components: hooks
>            Reporter: Ash Berlin-Taylor
>            Priority: Major
>              Labels: mysql
>
> This function executes {{LOAD DATA LOCAL ... }}which is disabled by default in MySQL 8 due to security concerns:
> https://dev.mysql.com/doc/refman/8.0/en/load-data-local.html



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)