title: mysql aes_decrpyt returns incorrect value
body: <p>Am using the following query in phpmyadmin on a XAMPP test environment:</p>
  
  <p>SELECT AES_DECRYPT( AES_ENCRYPT('password1','secret'),'secret');</p>
  
  <p>(see <a href="http://coderlearner.com/MySQL_Encryption-Decryption_Example_AES_DECRYPT" rel="nofollow">MySQL Encryption-Decryption Example AES DECRYPT</a></p>
  
  <p>This query SHOULD return <strong>password1</strong>, however, it is actually returning <strong>70617373776f726431</strong></p>
  
  <p>Any suggestions as to why?</p>
  
  <hr>
  
  <p>Database server</p>
  
  <p>Server: 127.0.0.1 via TCP/IP
  Server type: MySQL
  Server version: 5.6.16 - MySQL Community Server (GPL)
  Protocol version: 10
  User: 
  Server charset: UTF-8 Unicode (utf8)</p>
  
  <p>Web server</p>
  
  <p>Apache/2.4.9 (Win32) OpenSSL/1.0.1g PHP/5.5.11
  Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $
  PHP extension: mysqli</p>