Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
ajomat
Frequent Visitor

Access issues for MySQL database when using copy data activity in data Pipeline

Hi,

I was trying to use copy data activity in data pipeline for importing data from MySQL database. But its showing the below error message.

ajomat_0-1715698892934.png

Unable to connect to the mysql server, errorMsg: Access denied for user ''@'<ip Addrerss>' (using password: NO) Access denied for user ''@'<ip Addrerss>' (using password: NO) Activity ID: <activity id>

 

ajomat_1-1715699474218.png

 

But at the same time I am able to use Dataflow Gen 2 to access the same MySQL database with the same credintials.

Anyone know then why I am getting the above error while using the copy activity in data pipeline ? Appreciate any kind of help.

Thanks in advance! 

1 ACCEPTED SOLUTION
ajomat
Frequent Visitor

Hi @v-cboorla-msft 
Thank you for your response.
Today, it worked after the latest update of gateway.
Once again thank you for extending your help and support.

View solution in original post

2 REPLIES 2
ajomat
Frequent Visitor

Hi @v-cboorla-msft 
Thank you for your response.
Today, it worked after the latest update of gateway.
Once again thank you for extending your help and support.

v-cboorla-msft
Community Support
Community Support

Hi @ajomat 

 

Thanks for using Microsoft Fabric Community.

 

The error message "Access denied for user ''@'<ip Addrerss>' (using password: NO)" indicates that the Microsoft Fabric using Pipeline copy activity is unable to connect to your MySQL server due to permission issues.

Ensure you have entered the correct username and password for a user with appropriate access to the MySQL database in the Pipeline copy activity configuration. Double-check for typos.

If the issue still persists, please do let us know. Glad to help.

 

I hope this information helps.

 

Thank you.

 

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.