MySQL Forums
Forum List  »  Security

AES_ENCRYPT() in php
Posted by: Trevor Herselman
Date: December 19, 2005 08:48AM

Is there a way of getting the MySQL AES_ENCRYPT() and php's mcrypt() (with MCRYPT_RIJNDAEL_128) to encrypt/decrypt data between them (in other words "to be compatible"). As far as I know, the only difference between the two (from a begginners point of view) was the fixed/variable length keys used. I've tried every encryption mode available in mcrypt() to get them working (with/without an initialization vector, I presume the MySQL version is not using an iv).

I just would like a 'backup' method if anything goes wrong. Also, I might be hosting a website on a shared host, possibly without MySQL over SSL, so I don't want to use the MySQL version, but when the site gets bigger, or I move it, it's possible that the MySQL version could become a viable option in the future. So I just want to have a form of redundancy between the algo's! Also, the php host might not have mcrypt installed.

Also, could someone tell me what mode the AES_ENCRYPT() function in MySQL is using!


Edited 2 time(s). Last edit at 12/19/2005 08:50AM by Trevor Herselman.

Options: ReplyQuote

Written By
AES_ENCRYPT() in php
December 19, 2005 08:48AM
March 10, 2006 01:21PM
April 19, 2006 08:57PM
May 08, 2006 02:04PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.