mysql使用Aes加解密

最新推荐文章于 2024-02-03 15:57:43 发布

Wind Drift

最新推荐文章于 2024-02-03 15:57:43 发布

阅读量886

点赞数

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/Wind___Drift/article/details/130659151

版权

SET block_encryption_mode = 'aes-256-cbc';SET @KEY = 'JGe7aPAMNiS1x6BI';
SET @iv = 'Z84HIR7znTEMLkOI';
SELECT
TO_BASE64 (
AES_ENCRYPT( '13669091204', @KEY, @iv )) AS phone;
SELECT CONVERT
( AES_DECRYPT( FROM_BASE64 ( 'dkicrOxIgGNcxW3leghbzw==' ), @KEY, @iv ) USING UTF8 ) AS phone;


SET block_encryption_mode = 'aes-256-ecb'; select TO_BASE64(AES_ENCRYPT('13669091204','EMc5GPSDUNujzHNSzVcvSLZXdubZ3kHK')) as phone ; SET block_encryption_mode = 'aes-256-ecb'; select Convert(AES_DECRYPT( FROM_BASE64('dR1d77KGVNI+Omfc9Lbjzw=='),'EMc5GPSDUNujzHNSzVcvSLZXdubZ3kHK') USING UTF8) as phone;