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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
herbemischung
Resolver I
Resolver I

MySQL: Authentication method 'caching_sha2_password' not supported by any of the available plugins

Hi, another day, another problem 😞

 

We had to change the Server of our database. It now runs on another MySQL Version. I tried to refresh my Report but all I got was this error-message: "MySQL: Authentication method 'caching_sha2_password' not supported by any of the available plugins"

 

Does anyone have an idea what I can do about it?

 

Thanks!! 

 

1 ACCEPTED SOLUTION

thanks a lot. It turned out, that I needed to update my MySQL Connector. 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

@herbemischung Could you please share the link for the MySQL Connector? 

I tried to download the latest version but it did not work.

 

v-juanli-msft
Community Support
Community Support

Hi @herbemischung 

Do you connect to one MySQL server with Power BI, then you switch the connection to another MySQL server?

If so, how do you make this change?

Please follow this video:

Power BI - How to change a DataSource Connection in PBIX

 

As searched, there are some suggestions to slove the error you provided:

Failed to load caching_sha2_password authentication plugin [Solved]

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

thanks a lot. It turned out, that I needed to update my MySQL Connector. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.