MySQL Password encryption method

With MySQL version 4.1 as the dividing line, two kinds of encryption methods

Mysql323 Encryption: (16-bit)

Select Old_password (' root '); MySQL self-encrypting function old_password (str)

Select  Old_password ('root'); +----------------------+| Old_password ('root') |+----------------------+| 67457E226A1A15BD     |+----------------------+1inset (0.00 sec)

MysqlSHA1 encryption: (minus the * number 40 bits, one-way encryption, can only be matched through the password library)

Select password (' root '); MySQL self-encrypting function password (str)

Select password ('root'); +-------------------------------------------+| Password ('root')                          |+-------------------------------------------+| * 81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |+-------------------------------------------+1 in Set (0.00 sec)

MySQL Password encryption method