| Bug #115721 | MySQL Workbench Invalid Authentication Plugin | ||
|---|---|---|---|
| Submitted: | 29 Jul 2024 20:33 | Modified: | 30 Jul 2024 4:45 |
| Reporter: | David Garratt | Email Updates: | |
| Status: | Won't Fix | Impact on me: | |
| Category: | MySQL Workbench: Administration | Severity: | S2 (Serious) |
| Version: | 8.0.38 | OS: | MacOS (Sonoma 14.5) |
| Assigned to: | CPU Architecture: | ARM (M3) | |
| Tags: | Authentication plugin, workbench | ||
[30 Jul 2024 4:45]
MySQL Verification Team
Hello David Garratt, Thank you for the report and feedback. regards, Umesh
[14 Sep 18:06]
Omer Barnir
Posted by developer: This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained. MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation. Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.
Description: Connecting to a mySQL Server 9.x and potentially any version after 8.1 generates a compatibility warning - but does allow you to connect. However - using the Workbech to try and create a user account just fails with Invalid Authentication Plugin User newuser@%% has plugin type None, which is not listed as a known authentication plugin by the server. How to repeat: As above. I have tried this with mySQL Server installed under MacOS and in a docker container. I am runing mySQL Workbech in MacOS. Connect to database Create a Schema Try to add user. Suggested fix: Make mySQL Workbench compatible to mySQL Server