MySQL Bugs: #84876: Creating and modifying users with auth

Bug #84876	Creating and modifying users with auth_socket fails
Submitted:	8 Feb 2017 9:36	Modified:	8 Feb 2017 10:33
Reporter:	Daniël van Eeden	Email Updates:
Status:	Won't Fix	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	6.3.9	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	auth_socket, authentication plugins, unix domain socket

Description:
- I can't change the authentication method for an existing user with auth_socket
- Creating a new user with auth_socket fails (see below for details)
- It warns me about the security hazard of creating an account without password, which doesn't make sense when using auth_socket.

How to repeat:
10:31:43 [ERR][       pymforms]: Unhandled exception in Python code: 'auth_socket'
<traceback object at 0x7f2fed7b25a8>
10:31:43 [ERR][         python]: Error forwarding notification to PythonTraceback (most recent call last):
10:31:44 [ERR][         python]:   File "/usr/share/mysql-workbench/libraries/workbench/notifications.py", line 31, in _the_observer
10:31:44 [ERR][         python]:     for obs, nam, obj in self.observers:
10:31:44 [ERR][         python]:   File "/usr/lib64/mysql-workbench/modules/wb_admin_security.py", line 2012, in commit
10:31:44 [ERR][         python]:     if self._selected_user.auth_plugin and AUTHENTICATION_PLUGIN_TYPES[self._selected_user.auth_plugin]["auth_string_label"]:
10:31:44 [ERR][         python]: KeyError: 'auth_socket'

Suggested fix:
Test with WB with auth_socket

Hello Daniël,

Thank you for the report.
Verified as described.

Thanks,
Umesh

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.