Forum Discussion
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: A...
thanks a lot. It turned out, that I needed to update my MySQL Connector.
Hi Anonymous
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.