MySQL Error (2059): Shell.open_session: Authentication plugin 'mysql_clear_password' cannot be loaded: plugin not enabled

[Berowne]

Testing the new Oracle MySQL Shell DBConnection.
Our server is on AWS and requires a token for password which we usually copy/paste as it changes frequently.
However I can't use a clear text password.

MySQL Error (2059): Shell.open_session: Authentication plugin 'mysql_clear_password' cannot be loaded: plugin not enabled

[Berowne]

set LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=1

then restart vscode.