MySQL has a plugin that allows user authentication against current user’s Windows credentials. The plugin is ‘authentication_windows.dll’. When I set this in my.ini file, I can then connect to mysql using a Windows group of which I’m a member of and I don’t have to enter a password. This works great at the command prompt however when I try to connect using SQLyog, I get the following error message from SQLyog:
Error No. 2058
Plugin authentication_windows_client could not be loaded: The specified module could not be found.
The “authentication_windows_client” is a dll that is supposed to be loaded on the client side. Actually I think that SQLyog is looking for an older dll which has been replaced by MySQL with ‘libmysql.dll’.
How do I make SLQyog load the correct dll? I’ve tried registering the dlls using regsvr32 but that didn’t work.