Pathologically Eclectic Rubbish Lister | |
PerlMonks |
Re^11: plugin 'mysql_old_password' cannot be loadedby poj (Abbot) |
on Feb 21, 2019 at 20:51 UTC ( [id://1230328]=note: print w/replies, xml ) | Need Help?? |
Will remove the error with the missing mysql_old_password plugin ?
No, this is how I understand it ; Support for pre-4.1 password hashes was removed in MySQL 5.7.5 These versions should work with 16-byte hash (or 41-byte hash) Perl 5.20.3 (2016-03-08) comes with DBD-mysql 4.033 and mysql-5.1.44 so post 4.1 and pre 5.7.5 Perl 5.24.0.1 (2016-05-11) comes with DBD-mysql 4.033 and mysql-5.1.44 so post 4.1 and pre 5.7.5 This version should work only with 41-byte hash. Perl 5.24.1.1 (2017-01-16) comes with DBD-mysql 4.041 and mysql-5.7.16 so post 5.7.5. To use perl 5.24.1.1 either 1. For existing user (with 16-byte hash) generate a new 41-byte hash using SET PASSWORD FOR 'some_user'@'some_host' = PASSWORD('password'); If you do that any existing pre-4.1 client will not be able to use that user account. For info the first production version of mysql-4.1.7 was released in October 2004. note. PASSWORD_OLD('password') generates a 16-byte hash. or 2 Create a new user account (which will be by default a 41-byte hash) and use that. Any pre-4.1 clients could continue to use the old account.poj
In Section
Seekers of Perl Wisdom
|
|