MySQL Encryption and decryption

MySQL 4.1 is MySQL323 encryption, MySQL 4.1 and later versions are MySQLSHA1 encrypted,

(1) Encrypt in MySQL323 mode

Select Old_password (' 111111 ');

(2) Encrypt in MySQLSHA1 mode

Select password (' 111111 '); MYSQL323 encryption is generated in a 16-bit string, and in MySQLSHA1 is the existence of a 41-bit string, where * is not added to the actual cryptographic operation, by observing in many users have carried "*", in the actual cracking process to remove the "*",    That is to say, the actual number of MySQLSHA1 encrypted passwords is 40 bits. Update user set Password=password (' 123456 ') where user= ' root ';

MySQL Encryption and decryption