Could someone give me some advice on the best way to store sensitive information like credit card numbers on our mySQL database. Of course we would be using SSL encryption for all transactions.
Take a look here: http://www.mysql.com/doc/en/Miscellaneous_functions.html
There are functions for encrypt, encode, des_encrypt, and aes_encrypt. One should be right for you. I assume your also imposing some strict permissions and limiting the accounts that can read and write to those tables.
bob
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]