MySQL Database Password function

Executing the following sentence in the MySQL database generates a new, encrypted string for the string. The user stores the password in the database.

SELECT PASSWORD (' AA ')

The generated string starts with the * number. Like ' *dee59c300700af9b586f9f2a702231c0ac373a13 '.

SELECT old_password (' AA ');

Old_password is an older version of the cryptographic function, and the resulting string is 16 bits, such as ' AA ' after encryption is ' 077baf58491e1952 '.

This method of generating passwords relies on the database and requires a connection to the database with network overhead. Usually also uses the MD5 method to do the plaintext encryption.

MySQL Database Password function