Hello.
Where are you going to store the key? You could use subqueries for
manipulations with encrypted data. Here is the example, however,
you should turn of binary logging, because insert statements are being
stored with key.
create table pwd(id int auto_increment, pass char(100), prima
At 04:16 PM 7/12/2005, Matt McNeil wrote:
I need to securely store lots of sensitive contact information and
notes in a (MySQL or other freely available) database that will be
stored on a database server which I do not have direct access to.
This database will be accessed by a PHP application
I need to securely store lots of sensitive contact information and
notes in a (MySQL or other freely available) database that will be
stored on a database server which I do not have direct access to.
This database will be accessed by a PHP application that I am
developing. However, I also nee
See the section of the documentation on the password function.
Insert into users (username, password) values
('joesmith',password('somepassword'));
It will encrypt your passords. then you select using the same function.
select username, password from users where username = 'joesmith' and
passw
At 7:24 AM +0500 1/22/01, Muhammad Farhan Ghazi wrote:
>How one can make a field encrypted in a table, so that it cannot
>even be seen using the select statement? I have a field in which I'm
>storing passwords and I don't want it to be visible.
Making it visible or not isn't a matter of encrypt
How one can make a field encrypted in a table, so that it cannot even be
seen using the select statement? I have a field in which I'm storing
passwords and I don't want it to be visible.
Ghazi, Muhammad Farhan
_
Get Your P
