Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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!! 

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

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

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Anonymous Could you please share the link for the MySQL Connector? 

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