MYSQL_ AUTHENTICATION_ INTERFACE_ VERSION, Static struct st_mysql_auth pam_auth_handler= I'm not an expert in c or the mysql plugin api so I'm not sure why auth_pam_compat does not work the same. Downloading the Percona or MariaDB source code and modifying auth_pam.c to reference mysql_clear_ password instead of dialog and then compiling/ installing. It's possible windows workbench doesn't support dynamic client plugin loading. I'm not sure what path is used under windows. My guess is that workbench in Ubuntu uses the same library directory as mysql/percona while it does not in Windows. Ubuntu workbench does work if the shared & client packages are installed. The issue is that workbench does not support the dialog plugin.
I have done a good amount of investigation on this issue since filing the bug. "Ĭ:\Users\nilnandan>mysql -h192.168.42.52 -uapc_user -pĮRROR 2059 (HY000): Authentication plugin 'mysql_clear_password' cannot be loaded: plugin not enabledĬ:\Users\nilnandan>mysql -h192.168.42.52 -uapc_user -p -enable-cleartext-plugin With apc_user (compat), it can connect to server with -enable-cleartext-plugin via command prompt but getting error in workbench like "Access denied for user. Type '\c' to clear the current input statement. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. Server version: 5.5.35-33.0-log Percona Server (GPL), Release 33.0Ĭopyright (c) 2000, 2014, Oracle and/or its affiliates. "Ĭ:\Users\ nilnandan> mysql -h192.168.42.52 -uapc_user -pĮRROR 2059 (HY000): Authentication plugin 'mysql_ clear_password' cannot be loaded: plugin not enabledĬ:\Users\ nilnandan> mysql -h192.168.42.52 -uapc_user -p -enable- cleartext- plugin With apc_user (compat), it can connect to server with -enable- cleartext- plugin via command prompt but getting error in workbench like "Access denied for user 'apc_user' 42.52. Give below error.Ĭ:\Users>mysql -h192.168.42.52 -uap_user -pĮRROR 2059 (HY000): Authentication plugin 'dialog' cannot be loaded: The specifed module could not be found. With ap_user, it can't connect to MySQL server via command prompt as well as workbench. Reproduced the same issue with W7, WB 6.0.9 and MySQL 5.5.35
0 kommentar(er)
