Use MySQL encryption and decryption method to deal with level three security level protection

--Create a test table

drop table if EXISTS t_passwd_2;

CREATE TABLE T_passwd_2 (Pass1 varchar (64));

--Encrypt the ID number
INSERT into t_passwd_2 values (Hex (aes_encrypt (' 22230119771011001X ', ' [email protected]# ')]);

--The way the database is stored
SELECT * from T_passwd_2;


--Decryption
Select Aes_decrypt (Unhex (PASS1), ' [email protected]# ') as Pass1 from T_passwd_2;

Use MySQL encryption and decryption method to deal with level three security level protection