mysql-aes

A Node.js implementation of MySQL aes_encrypt and aes_decrypt

Credits

mysqljs/mysql#419 (comment)

Install

$ npm i mysql-aes --save

API

const AES = require('mysql-aes')

return type	signature	equal in mysql
String	AES.encrypt(str, key)	SELECT HEX(AES_ENCRYPT(str, key))
String	AES.decrypt(encrypted, key)	SELECT CAST(AES_DECRYPT(UNHEX(encrypted), key) as CHAR)

Changelog

CHANGELOG.md

License

the MIT License http://magicdawn.mit-license.org