学步园

.

I am aware that this is certainly not an easy topic (see also
http://lists.mysql.com/mysql/101724) I can expect to be solved in the short time, but if
I could say that MySQL DBMS can do that, it certainly is a very good selling argument
when proponing to choose MySQL for a professional project even if those features are not
used in the beginning and perhaps never since the design minimized the need to store
sensitive data altoghether or due to performance reasons...

For the related topic of password security on the windows mysql version, see
http://bugs.mysql.com/bug.php?id=784.

More somewhat related discussion I found: http://lists.mysql.com/mysql/140954

How to repeat:
.

Suggested fix:
.

[20 Oct 2003 9:03] Ralf Hauser

oops, column encryption is probably handled byhttp://www.mysql.com/doc/en/Miscellaneous_functions.html such as AES_ENCRYPT, but tableencryption still remains needed!Also, some hints, how to protect the keys outside mysql would be useful in pageMiscellaneous_functions.html

[25 Dec 2006 10:30] Sveta Smirnova

Thank you for the reasonable feature request.Right now you can use VIEW + TRIGGERS + STORED PROCEDURES to realize table encryptionfunctionality.

[13 Oct 2007 15:21] Steve OA

You can use commercial softwares for the same purpose e.g.http://solutions.mysql.com/solutions/item.php?id=431

[13 Oct 2007 15:22] Steve OA

i.e. Security-GENERAL from www.packetgeneral.com