Bug #115721 MySQL Workbench Invalid Authentication Plugin
Submitted: 29 Jul 20:33 Modified: 30 Jul 4:45
Reporter: David Garratt Email Updates:
Status: Verified Impact on me:
None 
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

[29 Jul 20:33] David Garratt
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
[30 Jul 4:45] MySQL Verification Team
Hello David Garratt,

Thank you for the report and feedback.

regards,
Umesh