Comments on: Upgrading passwords from old_passwords to “new passwords” https://shlomi-noach.github.io/blog/mysql/upgrading-passwords-from-old_passwords-to-new-passwords Blog by Shlomi Noach Tue, 04 Nov 2014 15:53:36 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: How to fix “Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password]” authentication error | JOZEF JAROSCIAK BLOG https://shlomi-noach.github.io/blog/mysql/upgrading-passwords-from-old_passwords-to-new-passwords/comment-page-1#comment-286663 Tue, 04 Nov 2014 15:53:36 +0000 https://shlomi-noach.github.io/blog/?p=3297#comment-286663 […] can reference following really nice article for more details about […]

]]> By: k srinivasan https://shlomi-noach.github.io/blog/mysql/upgrading-passwords-from-old_passwords-to-new-passwords/comment-page-1#comment-257458 Fri, 01 Aug 2014 10:43:28 +0000 https://shlomi-noach.github.io/blog/?p=3297#comment-257458 Workbench Version is 6.1 , It is connecting the command-line , But connect through WB or .net connectors it is showing Error Authentication plugin ‘mysql_clear_password’ cannot be loaded: plugin not enabled

]]> By: k srinivasan https://shlomi-noach.github.io/blog/mysql/upgrading-passwords-from-old_passwords-to-new-passwords/comment-page-1#comment-257457 Fri, 01 Aug 2014 10:42:18 +0000 https://shlomi-noach.github.io/blog/?p=3297#comment-257457 Workbench Version is 6.1 , It is connecting the command-line , But connect through WB or .net connectors.

]]> By: Peter Laursen https://shlomi-noach.github.io/blog/mysql/upgrading-passwords-from-old_passwords-to-new-passwords/comment-page-1#comment-257456 Fri, 01 Aug 2014 10:37:09 +0000 https://shlomi-noach.github.io/blog/?p=3297#comment-257456 Ok .. you are using Workbench.

Then think you should ask in the MySQL forms why WB does not connect to a server configured with LDAP. or even possible file a bug to bugs.mysql.com (if you think it is a bug).

But before doing anyting like this, first ensure that your WB version is updated. There is no idea in reporting bugs with older versions.

What about command-line client? Does it connect?

]]> By: k srinivasan https://shlomi-noach.github.io/blog/mysql/upgrading-passwords-from-old_passwords-to-new-passwords/comment-page-1#comment-257454 Fri, 01 Aug 2014 10:31:48 +0000 https://shlomi-noach.github.io/blog/?p=3297#comment-257454 it is not connecting WorkBench in the client system.

]]> By: Peter Laursen https://shlomi-noach.github.io/blog/mysql/upgrading-passwords-from-old_passwords-to-new-passwords/comment-page-1#comment-257433 Fri, 01 Aug 2014 09:17:14 +0000 https://shlomi-noach.github.io/blog/?p=3297#comment-257433 It could be a client side problem. ‘clear text plugin’ needs to be supported in the client. Only clients built with a recent connnector from Oracle do (not older Oracle connectors and not any connector from MariaDB).

What client are you using?

]]> By: k srinivasan https://shlomi-noach.github.io/blog/mysql/upgrading-passwords-from-old_passwords-to-new-passwords/comment-page-1#comment-257410 Fri, 01 Aug 2014 09:04:51 +0000 https://shlomi-noach.github.io/blog/?p=3297#comment-257410 Hi , thanks for your replay , I have installed Percona PAM authentication plugin. We connect through LDAP. It is showing mysql_clear_password’ cannot be loaded error only. Kindly some more ideas.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/upgrading-passwords-from-old_passwords-to-new-passwords/comment-page-1#comment-257390 Fri, 01 Aug 2014 08:48:26 +0000 https://shlomi-noach.github.io/blog/?p=3297#comment-257390 This has nothing to do with old_passwords. Are you trying to work with MySQL authentication plugin? Did you issue INSTALL PLUGIN? Just follow the manual on how to install plugins.

]]> By: k srinivasan https://shlomi-noach.github.io/blog/mysql/upgrading-passwords-from-old_passwords-to-new-passwords/comment-page-1#comment-257370 Fri, 01 Aug 2014 06:54:48 +0000 https://shlomi-noach.github.io/blog/?p=3297#comment-257370 Hi I am using LDAP , There is no password is stored in mysql , I have include old_passwords=1 in my.cnf file also , Still i am getting the below error — Error No:2059 , Authentication plugin ‘mysql_clear_password’ cannot be loaded: plugin not enabled , how to solve the problem ?

]]> By: Some MySQL security tips | code.openark.org https://shlomi-noach.github.io/blog/mysql/upgrading-passwords-from-old_passwords-to-new-passwords/comment-page-1#comment-255921 Mon, 28 Jul 2014 09:14:01 +0000 https://shlomi-noach.github.io/blog/?p=3297#comment-255921 […] Upgrading passwords from old_passwords to "new passwords" […]

]]>