Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re^5: plugin 'mysql_old_password' cannot be loaded

by poj (Abbot)
on Feb 19, 2019 at 15:06 UTC ( [id://1230170]=note: print w/replies, xml ) Need Help??


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

if I had to ask my DB Admin.

Ask what the length is of the string in the user.password field

SELECT LENGTH(PASSWORD) FROM USER 
WHERE USER = 'yourusername'
poj
  • Comment on Re^5: plugin 'mysql_old_password' cannot be loaded

Replies are listed 'Best First'.
Re^6: plugin 'mysql_old_password' cannot be loaded
by frazap (Monk) on Feb 20, 2019 at 15:46 UTC

    Result: 16

      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

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others scrutinizing the Monastery: (3)
As of 2024-04-25 17:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found