Shulou(Shulou.com)06/01 Report--

How to encrypt and decrypt passwords in MySQL? Many people do not understand, today Xiaobian in order to let you know more about the MySQL password encryption and decryption methods, so for you to summarize the following content, let's look down.

Detailed explanation of MySQL password encryption and decryption

There are a variety of front-end encryption algorithms for data encryption and decryption, which is a simple database-level data encryption and decryption solution.

Take the MySQL database as an example, it has built-in encryption function (AES_ENCRYPT ()) and decryption function (AES_DECRYPT ()).

1. Table creation: pay attention to the type of data when creating a table

CREATE TABLE users (username VARCHAR (10), PASSWORD VARCHAR (10), testpswd VARBINARY (20))

This table has three fields, 'user name', 'password', and 'encrypted password'.

two。 Insert data into a table

INSERT INTO users (username,PASSWORD,testpswd) VALUES ('sxyu','1233210',AES_ENCRYPT (' 1233210)

To insert a record, the AES_ENCRYPT () function needs a "key" to help with encryption, and decryption also needs it, which needs to be kept in mind.

3. Query encrypted data from the table (decryption):

SELECT username,PASSWORD,AES_DECRYPT (testpswd,'key') FROM users

From the query results, it can be found that the decrypted password is the same as the original password.

On how to encrypt and decrypt passwords in MySQL to share here, of course, not only the above and everyone's analysis methods, but the editor can ensure its accuracy is absolutely no problem. I hope that the above content can have a certain reference value for everyone, and can be put into practice. If you like this article, you might as well share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.