Bug #66638 Invalid Authentication plugin

• Submitted: 31 Aug 2012 21:27
• Modified: 27 Dec 2012 22:00
• Reporter: Ernesto Rodriguez
• Status: Closed
• Category: MySQL Workbench: Administration
• Severity: S2 (Serious)
• Version: 5.2.42
• OS: Windows (Server 2008 R2)
• CPU Architecture: Any

[31 Aug 2012 21:27] Ernesto Rodriguez

Description:
when you add users with authentication type standard, you get dialog box, invalid authentication plugin: user has plugin type mysql_native_password, which is not listed as a known authenticaion plugin by the server.

This a new install of mysql server 5.6.6 and WB 5.2.42

How to repeat:
this happen everytime you add users.

Suggested fix:
i can add users fine via command line using mysql with out any problem. Also i uninstalled WB and installed an older verion 5.2.34 and it works fine.

[2 Sep 2012 2:35] MySQL Verification Team

Thank you for the bug report.

[5 Dec 2012 18:31] Alfredo Kojima

Does this still happen with a newer version of the server? What do you get for SHOW PLUGINS in that server?

[27 Dec 2012 22:00] Philip Olson

Fixed as of MySQL Workbench 5.2.45, and here's the changelog entry:

Creating a standard user with MySQL Server 5.6 would sometimes fail, and
emit an error that referred to an unknown "mysql_native_password" plugin.

Thank you for the bug report.

[9 Feb 2015 17:11] Stan Byford

I also have this issue, tried workarounds but my application still reports unable to connect to mysql, and it seems when I attempt to check the user it shuts down the instance of mysql that's running