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