From: "sachin shetty" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED] >
Sent: Thursday, August 09, 2001 2:56 PM
Subject: Encrypt Database data
> Is there a way to encrypt database data and to let only one user decrypt
> when server and client runs on the same machine? I am aware of the fact
> that this is not fool proof scecurity as the decryption happens in the
> memory and not hard to steal..but i guess its for a short time and would
> be complex ..
The easiest way to do this would be to only allow one user access to the
database with:
GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'password'
WITH GRANT OPTION;
This should only allow user 'username' to access the database from the local
machine.
Alex
--
Alex Page, IT Department, Solid State Logic
E-Mail: [EMAIL PROTECTED]
Phone: +44 (0) 1865 842 300
Web: http://www.solid-state-logic.com
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
---------------------------------------------------------------------
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
