All Products
Search

This Product

    :When apsaradb for RDS runs a "load data infile" statement, the system prompts "Access denied for user"

    Document Center

    :When apsaradb for RDS runs a "load data infile" statement, the system prompts "Access denied for user"

    Last Updated:May 20, 2022

    Problem description

    No permission when apsaradb for RDS runs the load data infile statement.

    ERROR 1045 (28000): Access denied for user 'XXX'@'%' (using password: YES)

    Cause

    By default, apsaradb for RDS does not support permission policies.

    Solution

    Alibaba Cloud reminds you that:

    • Before you perform operations that may cause risks, such as modifying instance configurations or data, we recommend that you check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
    • You can modify the configurations and data of instances including but not limited to Elastic Compute Service (ECS) and Relational Database Service (RDS) instances. Before the modification, we recommend that you create snapshots or enable RDS log backup.
    • If you have authorized or submitted sensitive information such as the logon account and password in the Alibaba Cloud Management Console, we recommend that you modify such information in a timely manner.

    When executing the load data infile statement, you must add the local parameter, for example, load data local infile.

    Scope

    • ApsaraDB RDS instance