Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re^6: plugin 'mysql_old_password' cannot be loaded

by frazap (Monk)
on Feb 20, 2019 at 15:46 UTC ( [id://1230263]=note: print w/replies, xml ) Need Help??


in reply to Re^5: plugin 'mysql_old_password' cannot be loaded
in thread plugin 'mysql_old_password' cannot be loaded

Result: 16

Replies are listed 'Best First'.
Re^7: plugin 'mysql_old_password' cannot be loaded
by poj (Abbot) on Feb 21, 2019 at 08:03 UTC

    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
      Result: *DEFC3C96B99362885AD525B7AD2A5F02EED43E57

      F

        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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1230263]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (4)
As of 2024-03-28 18:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found