MySQL Bugs: #112931: MySQL Workbench Connection Error for empty authentication plugin

Bug #112931	MySQL Workbench Connection Error for empty authentication plugin
Submitted:	1 Nov 2023 19:08	Modified:	12 Jan 13:31
Reporter:	Marc Hassan (OCA)	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	8.0.32	OS:	MacOS
Assigned to:		CPU Architecture:	x86

Description:
Since MySQL Workbench 8.0.32, I am no longer able to connect to certain MySQL (MongoDB BI Connector) instances. With MySQL Workbench 8.0.31 and earlier, there is no issue.

```
The error looks like this:
Your connection attempt failed for user '<user>' to the MySQL server at <host>:<port>:
Authentication plugin '' cannot be loaded: dlopen([<host>]/.so, 0x0002)
```

I am looking at the difference between 8.0.31 and 8.0.32, and this line stood out to me: https://github.com/mysql/mysql-workbench/commit/27264473690c135be38359bb203180501ec40cb5#d...

Is it possible that `properties["defaultAuth"] = ""` is problematic?

I see there are already some `properties` that shouldn't be empty strings: https://github.com/mysql/mysql-workbench/blob/fc55741c444d4822234ab189612b877732115d88/lib.... Should `defaultAuth` be added to this list?

How to repeat:
I'm not sure

Suggested fix:
Either:
1. Remove `properties["defaultAuth"] = ""` that was added in https://github.com/mysql/mysql-workbench/commit/27264473690c135be38359bb203180501ec40cb5#d...
2. Add `defaultAuth` to the list of "empty values that may confuse the connector" at https://github.com/mysql/mysql-workbench/blob/fc55741c444d4822234ab189612b877732115d88/lib...

Additional information:
* I can replicate this issue in Ubuntu
* I have opened a PR here: https://github.com/mysql/mysql-workbench/pull/40

Additional information:
* If I add `defaultAuth=` to the `Advanced -> Others` section in version 8.0.31, I get the same error. This is further evidence that `properties["defaultAuth"] = ""` is the cause of the issue.

Hello Marc Hassan,

Thank you for the bug report.
Please note that in order to submit contributions you must first sign the Oracle Contribution Agreement (OCA). More details are described in "Contributions" tab, please ensure to re-send the patch via that tab. Otherwise we would not be able to accept it.

Regards,
Ashwini Patil

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

re-open

diff (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: diff.patch (application/octet-stream, text), 585 bytes.

Hello Marc Hassan,

Thank you for the details.
Discussed this issue internally with the MySQL Workbench developer and confirmed that MongoDB is not supported.

Regards,
Ashwini Patil