At 12:11 AM 2/11/2007, you wrote:
This is true, if the db is still on same db server.
Correct me if I am wrong, but it will not protect if some body copies the
files to other DB server, then they can see the DB
Suhas
Suhas,
You are correct. If the person has physical access to the MySQL
table, then there is nothing you can do to protect it unless you want to
encrypt individual columns using functions like AES_Encrypt() . But then
you lose the ability to use "<" or ">" on those column indexes. See
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html for more info.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
