?
Solved

Encryption using AES_ENCRYPT

Posted on 2011-04-27
4
Medium Priority
?
556 Views
Last Modified: 2012-06-21
Hi,

Wanted an expert advice on mysql aes_encrypt function.
i'm using this to encrypt some sensitive data using a key. i wanted to be sure if this is a good way and will not put me in a tricky situation when mysql upgrades happen especially major upgrades like 5.0 to 5.1 and to 5.5 and later 6.0

please help
0
Comment
Question by:harvest-soft
  • 2
  • 2
4 Comments
 
LVL 41

Accepted Solution

by:
ralmada earned 1500 total points
ID: 35475422
I don't think you will encounter any issues. There was one reported for 4.1 to 5.0, see
http://bugs.mysql.com/bug.php?id=32841

But nothing for 5.0 to 5.1 or newers.

0
 

Author Comment

by:harvest-soft
ID: 35480581
I guess we should test this before really migrating to new version of MySQL.

Thanks.
0
 
LVL 41

Expert Comment

by:ralmada
ID: 35481023
That's for sure! Any changes you made to your environment should be tested before moving it to production.
0
 

Author Closing Comment

by:harvest-soft
ID: 35502350
ok
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this article, we’ll look at how to deploy ProxySQL.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month15 days, 12 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question