AES_ENCRYPT in MySQL and PHP encryption are not giving the same output.
Here i am getting problem with encryption of data using PHP and MySQL. Actually we need to encrypt the data with 256 bit. So we have downloaded and compiled the source of MySQL and installed in CentOS. The problem is, suppose we encrypt the data using the PHP function(mcrypt_encrypt() with 256 bit) and if we decrypt the same data using MySQL decrypt function(AES_DECRYPT()) it is not giving the same output. Can you please suggest how to proceed?