MySQL encryption and decryption examples

MySQL encryption and decryption examples

Data encryption and decryption are very important in the security field. For programmers, storing user passwords in ciphertext in the database is of great significance to intruders who steal user privacy.
There are a variety of front-end encryption algorithms that can be used for data encryption and decryption. Here I recommend a simple database-level data encryption and decryption solution. Taking the MySQL database as an example, it has built-in corresponding encryption functions (AES_ENCRYPT()) and decryption functions (AES_DECRYPT()).

When building a table, pay attention to the type of field. As shown in the following figure:

Insert encrypted data into the table

The above insert statement has three fields, "Username", "Password" and "Encrypted Password". The AES_ENCRYPT() function requires a "key" to assist with encryption, and it is also required for decryption (remember this!).

The following is a screenshot of the data in the table:

The above insert statement has three fields, "Username", "Password" and "Encrypted Password". The AES_ENCRYPT() function requires a "key" to assist with encryption, and it is also required for decryption (remember this!).

The following is a screenshot of the data in the table:

Query encrypted data from the table

The query above uses the AES_DECRYPT() function. Here are the results:

In the above screenshot, we can see that the values ​​of the "pasword" and "decryptedpassword" fields are the same, that is, you have decrypted the user password.

Thank you for reading, I hope it can help you, thank you for your support of this site!