i'd like to setup a system that would allow for sensitive information to be encoded (like cc numbers), however having different keys for encoding & decoding the data.
found these in the manual, but they use the same pass_str. ENCODE(str,pass_str) Encrypt str using pass_str as the password. To decrypt the result, use DECODE(). The results is a binary string of the same length as string. If you want to save it in a column, use a BLOB column type. DECODE(crypt_str,pass_str) Descrypts the encrypted string crypt_str using pass_str as the password. crypt_str should be a string returned from ENCODE(). looking for something like encrypt(str, protected_str) and decrypt (crypt_str, private_str) and probably a make_key_pair() its not a vital part of my current project, but i'm sure someone will get cracked into (again) and then there will be another wave of secerity scares. (which again will die when they find out it was something silly like the employee who they where firing at the end of the week was the 'hacker') also, i can't seem to find much documentation on using ssl/x509 with mysql, anyone know of any good sites for this information? -- mysql, sql, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
