The authentication, the first level of security for each IT system, is the stage to verify the user identity through the basic username and password scheme. It is crucial to have a mechanism to protect and secure password storing and transmitting over network.
In MySQL, there is plenty of different authentication methods available, and last versions improved the security of this concept.
At the beginning, the mechanism, called mysql_old_password, was
pretty insecure: it’s based on a broken hashing function and the
password is 16 bytes long. It was not so complex for attackers to
find a plaintext password from the hash stored in the
password column of …
