why am I getting the 'authentication plugin " cannotbe loaded' error when I try to connect mySQl workbench to azure mySQL

Question

I am entirely new to Azure and mySQL. have create a mySQL server that I can connect to using azure CLI on the server. However trying to connect from my home PC using mySQL Workbench I get a ' Failed to Connect to mySQL error with the detail stating 'Authentication plugin " cannot be loaded. The specified module could not be found.

Answer 1

Hello Sean Campbell

There are multiple reasons why error "MySQL Workbench not being able to load the authentication plugin" may happen.

Here are a few steps you can try to resolve this issue:

• This is a known issue after upgrading to MySQL Workbench 8.0.401. If you're using version 8.0.40, try downgrading to version 8.0.38, as this version didn't have the issue
  https://bugs.mysql.com/bug.php?id=116413
• Uninstall MySQL Workbench and reinstall the latest version. This can help ensure that all necessary components are correctly installed.

https://forums.mysql.com/read.php?152,727710,727759