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

Question

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

Answer 1

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?