How to fix SELECT command denied to user 'mysqldevuser'@'20.38.83.85' for table 'my_table'

Katla Nikitha 0 Reputation points
2023-07-17T14:12:13.48+00:00

Hi team,

In Azure data factory while trying to preview data for my Azure Database for MySQL it is displaying the following error "SELECT command denied to user 'mysqldevuser'@'20.38.83.85' for table 'my_table'".

The connection with linked service is successful.

But I'm able to view the same table using the select query from MySQL Workbench editor.

Please let me know how I can solve this error with my MySQL database in Azure data factory.

Thank you,

Nikitha

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
671 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,068 questions
{count} votes

1 answer

Sort by: Most helpful
  1. SatishBoddu-MSFT 19,826 Reputation points
    2023-07-17T16:50:19.8033333+00:00

    Hello @Katla Nikitha, Welcome to Q&A forum,

    To confirm that the 'mysqldevuser' user has the necessary permissions to select data from the 'my_table' table, you can run the following command in MySQL Workbench:

    SHOW GRANTS FOR 'mysqldevuser'@'20.38.83.85';
    

    It is possible that there is a configuration issue with your Azure Data Factory instance. In this case, you can try the following steps:

    Check the firewall settings: Make sure that the IP address of the Azure Data Factory instance is added to the firewall settings for your Azure Database for MySQL instance.

    Have you consider this thing?

    0 comments No comments