Re^7: plugin 'mysql_old_password' cannot be loaded

Ok, looks like server has been upgraded from a pre 4.1 version.

Run this query to check if server is running with old_passwords=1

SELECT PASSWORD('anyword');

The result should be either

1483f47e284cee10 
or
*DEFC3C96B99362885AD525B7AD2A5F02EED43E57

poj

Comment on Re^7: plugin 'mysql_old_password' cannot be loaded Download Code

Replies are listed 'Best First'.
Re^8: plugin 'mysql_old_password' cannot be loaded by frazap (Monk) on Feb 21, 2019 at 10:49 UTC
Result: *DEFC3C96B99362885AD525B7AD2A5F02EED43E57 F	[reply]
Re^9: plugin 'mysql_old_password' cannot be loaded by poj (Abbot) on Feb 21, 2019 at 12:51 UTC
That's good, if your password field in the user table is char(41) ( get DBA to run 'describe myslq.user' query ) then Scenario 3 at bottom of this document suggests that resetting the password will create a long password hash. That should be more compatible with the later MySQL libraries. Be AWARE of the effect on pre-4.1 clients though. In scenario 3, accounts with short hashes become inaccessible to pre-4.1 clients if you change their passwords without explicitly using OLD_PASSWORD(). poj	[reply]
Re^10: plugin 'mysql_old_password' cannot be loaded by frazap (Monk) on Feb 21, 2019 at 13:46 UTC
Thanks ! I've found that this portable version of Strawberry include the version 4.033 of DBD::mysql, and the connection to the server works. Am I correct with saying that `SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('password');` [download] Will not change perl scripts (or other clients) that can connect now to keep on connecting ? Will remove the error with the missing mysql_old_password plugin ? F	[reply] [d/l]
Re^11: plugin 'mysql_old_password' cannot be loaded by poj (Abbot) on Feb 21, 2019 at 20:51 UTC