{"id":269,"date":"2021-11-17T14:50:28","date_gmt":"2021-11-17T14:50:28","guid":{"rendered":"https:\/\/ouritsource.com\/blog\/?p=269"},"modified":"2021-11-17T15:17:13","modified_gmt":"2021-11-17T15:17:13","slug":"different-encryption-methods-in-mysql","status":"publish","type":"post","link":"https:\/\/ouritsource.com\/blog\/different-encryption-methods-in-mysql\/","title":{"rendered":"Different Encryption Methods in MySQL"},"content":{"rendered":"\n

Below are examples of three different encryption methods to encrypt data inserted into a MySQL database table. <\/p>\n\n\n\n

A test table is created where field1 will store data in plain text and field2 will store encrypted data.<\/p>\n\n\n\n

CREATE TABLE encrypt_test\n(field1 varchar(255) null,\nfield2 varchar(255));<\/code><\/pre>\n\n\n\n
SHA1 Example<\/strong><\/p>\n\n\n\n
<\/p>\n\n\n\n
INSERT INTO encrypt_test(field1,field2) VALUES ('dd',SHA1('yoda'));\nSELECT * FROM encrypt_test WHERE field2=SHA1('yoda');<\/code><\/pre>\n\n\n\n
<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
SHA2<\/strong><\/p>\n\n\n\n
INSERT INTO encrypt_test(field1,field2) VALUES ('a',sha2('password',224));\nSELECT * FROM encrypt_test WHERE field2 = sha3('password',224));<\/code><\/pre>\n\n\n\n
<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
SELECT * FROM encrypt_test WHERE field2 = sha2('password',224));\n<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
AES_ENCRYPT<\/strong><\/p>\n\n\n\n
CREATE TABLE demodb\n(value blob);\n\nINSERT INTO demodb (demo) VALUES (AES_ENCRYPT('test to encrypt','PasswordKey'));\nSELECT CAST(AES_DECRYPT(value,'PasswordKey') as CHAR) FROM demodb;<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
SELECT CAST(AES_DECRYPT(value,'PasswordKey') as CHAR) = 'test to encrypt' FROM demodb;<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n<\/body>","protected":false},"excerpt":{"rendered":"
Below are examples of three different encryption methods to encrypt data inserted into a MySQL database table. A test table is created where field1 will store data in plain text and field2…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-269","post","type-post","status-publish","format-standard","hentry","category-miscellaneous","no-thumbnail"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/posts\/269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/comments?post=269"}],"version-history":[{"count":3,"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/posts\/269\/revisions"}],"predecessor-version":[{"id":277,"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/posts\/269\/revisions\/277"}],"wp:attachment":[{"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/media?parent=269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/categories?post=269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/tags?post=269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}