Unable to AES_DECRYPT after AES_ENCRYPT in mysql

by

According to the Manual:

AES_ENCRYPT() encrypts a string and returns a binary string.
AES_DECRYPT() decrypts the encrypted string and returns the original string.

I don’t know why it is still returning a binary string in your case. Anyway, try this:

SELECT *, 
       CAST(AES_DECRYPT(first_name, 'usa2010') AS CHAR(50)) first_name_decrypt 
FROM   user

And use first_name_decrypt instead of first_name.

More Related Contents:

  1. Encryption at rest and/or AES_ENCRYPT
  2. How to use `bcrypt` algorithm within `encrypt` function in MySQL for verifying password?
  3. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  4. 1052: Column ‘id’ in field list is ambiguous
  5. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  6. Count the occurrences of DISTINCT values
  7. Codeigniter – multiple database connections
  8. Column count doesn’t match value count at row 1
  9. How to add levenshtein function in mysql?
  10. How to search JSON data in MySQL?
  11. MySQL > Table doesn’t exist. But it does (or it should)
  12. Is the primary key automatically indexed in MySQL?
  13. How do I modify a MySQL column to allow NULL?
  14. Connect to mysql in a docker container from the host
  15. Is there ANY_VALUE capability for mysql 5.6?
  16. Set NOW() as Default Value for datetime datatype?
  17. MySQL update CASE WHEN/THEN/ELSE [duplicate]
  18. SQL DELETE with JOIN another table for WHERE condition
  19. How to connect to a MySQL Data Source in Visual Studio
  20. DOs and DONTs for Indexes [closed]
  21. MySQL: #1075 – Incorrect table definition; autoincrement vs another key?
  22. How can I implement single table inheritance using Laravel’s Eloquent?
  23. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  24. MySQL – ORDER BY values within IN()
  25. Integrity constraint violation: 1452 Cannot add or update a child row:
  26. MySQL Time Zones
  27. mysql_fetch_row() vs mysql_fetch_assoc() vs mysql_fetch_array() [duplicate]
  28. Mysql select where not in table
  29. Using DISTINCT and COUNT together in a MySQL Query
  30. Which DATATYPE is better to use TEXT or VARCHAR?

Leave a Comment