Bug #75657 MySQL server ships without authentication_windows.dll
Submitted: 27 Jan 2015 16:05 Modified: 27 Jan 2015 16:23
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL for Windows: Installer Severity:S3 (Non-critical)
Version:5.6.22 OS:Any
Assigned to: CPU Architecture:Any

[27 Jan 2015 16:05] Peter Laursen
Description:
http://dev.mysql.com/doc/refman/5.6/en/windows-authentication-plugin.html#windows-authenti...:

"To enable the plugin, start the server with the --plugin-load option. For example, put these lines in your my.ini file:

[mysqld]
plugin-load=authentication_windows.dll"

.. but there is no such file with a freshly installed MySQL 5.6.22 (using MySQL Installer) in C:\Program Files\MySQL\MySQL Server 5.6\lib where other plugin .dll's reside

How to repeat:
See above. I suppose that this may be a packaging issue with the MySQL Installer and it will be available from the .zip archive (but I have not checked yet) 

Suggested fix:
Include this plugin .dll with the MySQL Installer package. If a Windows Authentication Plugin is not relevant for a Windows Installer, where then?
[27 Jan 2015 16:18] Todd Farmer
Hi Peter,

Thanks for the bug report.  Just to be clear, are you observing this when using commercial-licensed MySQL Enterprise installer packages?  The Windows Authentication plugin is a commercial feature, and the plugin is not bundled with GPL-licensed community packages of MySQL.
[27 Jan 2015 16:21] Peter Laursen
OK .. that explains! I use COMMUNITY.
[27 Jan 2015 16:23] Todd Farmer
Thanks for confirming, Peter.  I'll close this as "Not a Bug", since this is expected behavior and documented as a commercial-only feature at the top of the cited documentation.  If you feel this needs further clarification, please advise.
[11 Aug 2016 21:51] Ashwin Kumar Boinala
i have installed commercial edition still i cant find .dll in  /usr/lib64/mysql/plugin/, a quick response is highly appreciated.
[11 Aug 2016 22:17] Todd Farmer
You won't find Windows .DLLs - or the Windows Authentication Plugin in any form - in Linux packages of MySQL.  This is a Windows-only plugin, and part of Commercial packages only.
[12 Aug 2016 4:21] Ashwin Kumar Boinala
Todd,

Thanks for your response.

I am using MYSQL commercial version on redhat linux,when I add plugin-load=authentication_windows.dll in my.cnf file and restarted MySQL service and when I query show plugins it shows nothing.

And I tried below method and I got error saying authentication_windows.dll is not available in  /usr/lib64/mysql/plugin/ .

Please let me know if I am doing anything wrong.

Thank you,
Ashwin
[12 Aug 2016 4:25] Ashwin Kumar Boinala
<<typo>>

Todd,

Thanks for your response.

I am using MYSQL commercial version on redhat linux,when I add plugin-load=authentication_windows.dll in my.cnf file and restarted MySQL service and when I query show plugins it shows nothing.

And I tried below method and I got error saying authentication_windows.dll is not available in  /usr/lib64/mysql/plugin/ .

INSTALL PLUGIN authentication_windows SONAME 'authentication_windows.dll'

Please let me know if I am doing anything wrong.

Thank you,
Ashwin
[15 Aug 2016 20:31] Ashwin Kumar Boinala
Thanks todd.
I misunderstood your comment, I am able to connect mysql-linux using PAM.