Authentication Plugins mysql>  SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE ’%windows%’; +------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +------------------------+---------------+ | authentication_windows | ACTIVE | +------------------------+---------------+ CREATE USER sql_admin IDENTIFIED WITH authentication_windows AS ’Rafal, Tasha, Administrators, "Power Users"’; If the plugin fails to initialize, check the server error log for diagnostic messages. To associate MySQL accounts with the Windows authentication plugin, see Using Windows Pluggable Authentication. Additional plugin control is provided by the authentication_windows_use_principal_name  and  authentication_windows_log_level system variables. See Section 5.1.8, “Server System Variables” . The method used to uninstall the Windows authentication plugin depends on how you installed it: UNINSTALL PLUGIN authentication_windows; In addition, remove any startup options that set Windows plugin-related system variables. The Windows authentication plugin supports the use of MySQL accounts such that users who have logged in to Windows can connect to the MySQL server without having to specify an additional password. It is assumed that the server is running with the server-side plugin enabled, as described in Installing Windows Pluggable Authentication. Once the DBA has enabled the server-side plugin and set up accounts to use it, clients can connect using those accounts with no other setup required on their part. To refer to the Windows authentication plugin in the  IDENTIFIED WITH  clause of a  CREATE USER statement, use the name  authentication_windows . Suppose that the Windows users  Rafal  and Tasha  should be permitted to connect to MySQL, as well as any users in the  Administrators  or  Power Users  group. To set this up, create a MySQL account named  sql_admin  that uses the Windows plugin for authentication: The plugin name is  authentication_windows . The string following the  AS  keyword is the authentication string. It specifies that the Windows users named  Rafal  or  Tasha  are permitted to authenticate to the server as the MySQL user  sql_admin , as are any Windows users in the Administrators  or  Power Users  group. The latter group name contains a space, so it must be quoted with double quote characters. After you create the  sql_admin  account, a user who has logged in to Windows can attempt to connect to the server using that account: C:\>  mysql --user=sql_admin 1330 Using Windows Pluggable Authentication •If you installed the plugin at server startup using a  --plugin-load-add  option, restart the server without the option. •If you installed the plugin at runtime using an  INSTALL PLUGIN  statement, it remains installed across server restarts. To uninstall it, use  UNINSTALL PLUGIN : Uninstalling Windows Pluggable Authentication