Bug #67308 Invalid Authentication Plugin Warning

Submitted: 21 Oct 2012 1:13 Modified: 30 Jan 2013 13:45
Reporter: Kris Pribadi Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.44 OS:Windows (Microsoft Windows 7 (build 7600), 64-bit)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[21 Oct 2012 1:13] Kris Pribadi
Description:
Unable to add users from Workbench. Missing mysql_native_password plugin error on SQL 5.6.7RC 

----- Developer Notes -----

MySQL Workbench CE for Windows version 5.2.44  revision 9933
Configuration Directory: C:\Users\kpribadi.SBS\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
OS: Microsoft Windows 7  (build 7600), 64-bit
CPU: 4x Intel(R) Core(TM) i5 CPU         750  @ 2.67GHz, 8.0 GiB RAM
Active video adapter (0): Glance Speed Boost
Installed video RAM: 0 MB
Current video mode: 1680 x 1050 x 4294967296 colors
Used bit depth: 32
Driver version: 2.0.110.0
Installed display drivers: NULL
Active video adapter (1): LogMeIn Mirror Driver
Installed video RAM: 0 MB
Current video mode: 1920 x 1080 x 4294967296 colors
Used bit depth: 32
Driver version: 7.1.542.0
Installed display drivers: NULL
Current user language: English (United States)

How to repeat:
Use Workbench with SQL 5.5.7RC and attempt to add user from Workbench
[22 Oct 2012 15:31] MySQL Verification Team
Thank you for the bug report.
[22 Oct 2012 15:43] MySQL Verification Team
Sorry I edited wrong bug report. Regarding this bug I am getting different behavior than reported I couldn't even to open the Manage Security screen I got and exception Current profile has no WMI enabled. Did you get that error message?. Thanks.
[23 Nov 2012 1:00] Bugs System
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".
[23 Nov 2012 18:59] Kris Pribadi
A work around?:

When adding a new user using MySQL Workbench on a MySQL 5.6.7RC, the username is added and a "mysql_native_password" entry is added by default to mysql.user.plugin column. Somehow, the Workbench is complaining about the missing mysql_native_password plugin. If I open the mysql.user table, I can clear the entry in the plugin column. This seems to work. (mysql is hidden in the Workbench object browser by default).
[30 Dec 2012 13:45] MySQL Verification Team
Please try version 5.2.45. Thanks.
[31 Jan 2013 1:00] Bugs System
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".

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.