Encrypt and Decrypt MYSQL

crypt.sql

CREATE TABLE `test` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARBINARY(100) NULL
PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;

INSERT INTO test (name)
VALUE (AES_ENCRYPT('valuegoeshere','secretkeygoeshere'));

SELECT AES_DECRYPT(name,'secretkeygoeshere') AS name_decrypt
FROM test;

SELECT id, AES_DECRYPT(name,'secretkeygoeshere') AS name_decrypt 
FROM test
where name = AES_ENCRYPT('valuegoeshere','secretkeygoeshere');

MySQL Crypt

This sample code is used to store and retrieve encrypted data from a MySQL database.