om/2016/02/17/how-is-cryptography-incorporated-into-pos-terminals/
For example, DES with a 56-bit key (2^56 possible
combinations) can
be broken in less than a day, since average computers
can perform a
billion operations per second. However, the addition of
more bits to
the string will expone
raphy-incorporated-into-pos-terminals/
For example, DES with a 56-bit key (2^56 possible combinations) can
be broken in less than a day, since average computers can perform a
billion operations per second. However, the addition of more bits to
the string will exponentially increase the time required to cra
Am 03.03.2016 um 16:40 schrieb lejeczek:
how to backup in a way that this in-database-encryption will be taken
advantage of?
does any of present backup solutions can do it?
many thanks
think once again what "transparent encryption" means
the most effective backup is anyways running slave con
raphy-incorporated-into-pos-terminals/
For example, DES with a 56-bit key (2^56 possible
combinations) can be broken in less than a day, since
average computers can perform a billion operations per
second. However, the addition of more bits to the string
will exponentially increase the time required to
ble combinations) can be broken
in less than a day, since average computers can perform a billion operations
per second. However, the addition of more bits to the string will exponentially
increase the time required to crack it.
Most SSL keys (for example, those used to encrypt the information
On 29/02/16 21:35, shawn l.green wrote:
On 2/29/2016 3:13 PM, Reindl Harald wrote:
Am 29.02.2016 um 20:54 schrieb Gary Smith:
On 29/02/2016 19:50, Reindl Harald wrote:
cryptsetup/luks can achieve that way better
Only to a degree.
no - not only to a degree - when the question is "not
On 2/29/2016 3:13 PM, Reindl Harald wrote:
Am 29.02.2016 um 20:54 schrieb Gary Smith:
On 29/02/2016 19:50, Reindl Harald wrote:
cryptsetup/luks can achieve that way better
Only to a degree.
no - not only to a degree - when the question is "not store anything
unencrypted on the disk" th
Am 29.02.2016 um 20:54 schrieb Gary Smith:
On 29/02/2016 19:50, Reindl Harald wrote:
cryptsetup/luks can achieve that way better
Only to a degree.
no - not only to a degree - when the question is "not store anything
unencrypted on the disk" the is no degree, but or if
Once the disk is
On 29/02/2016 19:54, Gary Smith wrote:
However, if TDE is employed, then you've got another significant
obstacle to overcome: The data is only encrypted (aiui) once it's in
memory.
Apologies, that should read "unencrypted (aiui) once it's in memory"
Gary
--
MySQL General Mailing List
For list
On 29/02/2016 19:50, Reindl Harald wrote:
cryptsetup/luks can achieve that way better
Only to a degree. Once the disk is unencrypted, you've got access to the
filesystem. If you've got physical access to the machine, then anything
which gives you console access gives you (potentially) access
Am 29.02.2016 um 20:30 schrieb shawn l.green:
Hi Reindl,
On 2/29/2016 2:16 PM, Reindl Harald wrote:
Am 29.02.2016 um 20:07 schrieb Jesper Wisborg Krogh:
Hi Lejeczek,
On 1/03/2016 00:31, lejeczek wrote:
hi everybody
a novice type of question - having a php + mysql, can one just encrypt
Hi Reindl,
On 2/29/2016 2:16 PM, Reindl Harald wrote:
Am 29.02.2016 um 20:07 schrieb Jesper Wisborg Krogh:
Hi Lejeczek,
On 1/03/2016 00:31, lejeczek wrote:
hi everybody
a novice type of question - having a php + mysql, can one just encrypt
(internally in mysql) tables and php will be fine
Am 29.02.2016 um 20:07 schrieb Jesper Wisborg Krogh:
Hi Lejeczek,
On 1/03/2016 00:31, lejeczek wrote:
hi everybody
a novice type of question - having a php + mysql, can one just encrypt
(internally in mysql) tables and php will be fine?
If not, would it be easy to re-code php to work with
Hi Lejeczek,
On 1/03/2016 00:31, lejeczek wrote:
hi everybody
a novice type of question - having a php + mysql, can one just encrypt
(internally in mysql) tables and php will be fine?
If not, would it be easy to re-code php to work with this new,
internal encryption?
Starting with MysQL
On 29/02/16 14:38, Steven Siebert wrote:
Simple answer is no. What are you trying to accomplish?
I was hoping that with this new feature (google's) where
mysql itself, internally uses keys to encrypt/decrypt tables
or tablespaces I could just secure data, simply.
Chance is I don't
Simple answer is no. What are you trying to accomplish?
S
On Mon, Feb 29, 2016 at 8:31 AM, lejeczek wrote:
> hi everybody
>
> a novice type of question - having a php + mysql, can one just encrypt
> (internally in mysql) tables and php will be fine?
> If not, would it be easy to
hi everybody
a novice type of question - having a php + mysql, can one
just encrypt (internally in mysql) tables and php will be fine?
If not, would it be easy to re-code php to work with this
new, internal encryption?
thanks.
--
MySQL General Mailing List
For list archives: http
> From: Johan De Meersman To:J Gao @
2013-07-19
> > From: "J Gao"
> > Subject: Transfer ENCRYPT password field to another server
> >
> > So, is there a way to make the MySQL encrypted password string
> > "2I6JOeg.JukJ." convert to MD5 ha
- Original Message -
> From: "J Gao"
> Subject: Transfer ENCRYPT password field to another server
>
> So, is there a way to make the MySQL encrypted password string
> "2I6JOeg.JukJ." convert to MD5 hash "$1$."?
Nope. Encrypt
Hi, All,
I am having trouble to transfer email user account which is saved in
MySQL to another server. Here is the detail:
I have an old email server which using MySQL to store user account
information. The password field uses MySQL ENCRYPT function to save the
users password. So if I want
Hi
how can encrypt the pw to use mysqldump
thank you
_
Find info faster and easier with Internet Explorer 8.
http://go.microsoft.com/?linkid=9655583
Hi all,
I've got an account table with password encrypted thru the encrypt() function,
and I should transfer them to a table with password() function. I don't want
to decrypt the password, and I'd like to know if there's a way to build the
password hash from the encrypt
mos schrieb:
I posted this message twice in the past 3 days, and it never gets on
the mailing list. Why?
Here it is again:
I have a Text field that contains paragraph text and for security
reasons I need to have it encrypted. If I do this, how can I still
implement full text search on it?
Als
From: Baron Schwartz <[EMAIL PROTECTED]>
To: mos <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Friday, October 26, 2007 3:54:11 PM
Subject: Re: How to encrypt Text and still be able to use full text search?
3rd Attempt ++
> I also need to protect a couple dozen Float fields
I also need to protect a couple dozen Float fields and thought I could
obscure them a bit by adding an offset to them based on an encrypted id
stored with each row. It is not going to be as good as encryption but
will help to obfuscate the data.
How much will obfuscation save you? Are you sav
At 01:47 PM 10/26/2007, you wrote:
On 10/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>
> [EMAIL PROTECTED] wrote:
> > mos wrote:
> >>
> >> The data is quite valuable because there is a lot of competition in
> >> this particular marketplace and my competitors would like to get their
> >> hand
At 12:31 PM 10/26/2007, you wrote:
[EMAIL PROTECTED] wrote:
mos wrote:
The data is quite valuable because there is a lot of competition in this
particular marketplace and my competitors would like to get their hands
on it. I've spent 5 years writing the software and generating the data.
Le
On 10/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>
> [EMAIL PROTECTED] wrote:
> > mos wrote:
> >>
> >> The data is quite valuable because there is a lot of competition in
> >> this particular marketplace and my competitors would like to get their
> >> hands on it. I've spent 5 years writing
[EMAIL PROTECTED] wrote:
mos wrote:
The data is quite valuable because there is a lot of competition in
this particular marketplace and my competitors would like to get their
hands on it. I've spent 5 years writing the software and generating
the data. Let's say for the sake of argument the
mos wrote:
The data is quite valuable because there is a lot of competition in this
particular marketplace and my competitors would like to get their hands
on it. I've spent 5 years writing the software and generating the data.
Let's say for the sake of argument the data is worth $1 million.
Ian,
At 09:36 AM 10/26/2007, you wrote:
On 26 Oct 2007 at 9:17, mos wrote:
> I posted this message twice in the past 3 days, and it never gets on the
> mailing list. Why?
> Here it is again:
>
> I have a Text field that contains paragraph text and for security
reasons I
> need to have it encr
On 26 Oct 2007 at 9:17, mos wrote:
> I posted this message twice in the past 3 days, and it never gets on the
> mailing list. Why?
> Here it is again:
>
> I have a Text field that contains paragraph text and for security reasons I
> need to have it encrypted. If I do this, how can I still imple
I posted this message twice in the past 3 days, and it never gets on the
mailing list. Why?
Here it is again:
I have a Text field that contains paragraph text and for security reasons I
need to have it encrypted. If I do this, how can I still implement full
text search on it?
Also, I have a lo
Jake Peavy <[EMAIL PROTECTED]> wrote on 11/26/2005 07:54:22 PM:
> Also, do you know if there is any way at all to do the tiniest amount of
> research on my own to find out even the most basic information about
MySQL
> without bothering an entire worldwide mailing list with my trivial
> questions?
Also, do you know if there is any way at all to do the tiniest amount of
research on my own to find out even the most basic information about MySQL
without bothering an entire worldwide mailing list with my trivial
questions?
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html
Luiz Rafael Culik Guimaraes wrote:
> Dear Friends
>
> is their any way to encrypt data saved to an mysql server?
>
> Regards
> Luiz
>
--
For technical support contracts, goto ht
Dear Friends
is their any way to encrypt data saved to an mysql server?
Regards
Luiz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thank you very much Paul.
EDWIN LIMACHI N.
Phone. 591-2-2123978
Movil: 591-715-29967
Fax: 591-2-2123975
Paul DuBois <[EMAIL PROTECTED]>
21/10/2004 15:56
Para
[EMAIL PROTECTED],
[EMAIL PROTECTED]
cc
Asunto
Re: ENCRYPT() function
At 15:41 -0400 10/21/04,
At 15:41 -0400 10/21/04, [EMAIL PROTECTED] wrote:
Dear list:
I have a short database with id,username and
password for authenticate my users with
freeradius. The passwords are encrypted through
ENCRYPT() function. I´d like to know why
ENCRYPT() function doesn´t give the same
encrypted string
Dear list:
I have a short database with id,username
and password for authenticate my users with freeradius. The passwords are
encrypted through ENCRYPT() function. I´d like to know why ENCRYPT() function
doesn´t give the same encrypted string for a clear text string?.
e.g. In the first time
y to a database that I am working on. This
database will be distributed and I need to prevent users from being able
to
simply copy the files and being able to have complete access to it. I want
to do this: "Encrypt the `.frm' file with a password. This option doesn't
do
t; <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I need to provide some security to a database that I am working on. This
> database will be distributed and I need to prevent users from being able
to
> simply copy the files and being able to have complete access to it. I wa
Exactly. Think "HIPAA" and the methods used to secure data from the
priying eyes of DBAs (supposedly) under HIPAA/Security.
Dan Greene wrote:
if the data is the concern, not the data structure, why not encrypt the data itself?
-Original Message-
From: David Crane [mai
if the data is the concern, not the data structure, why not encrypt the data itself?
> -Original Message-
> From: David Crane [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 11, 2004 2:15 PM
> To: [EMAIL PROTECTED]
> Subject: Re: how do i encrypt the .frm file with a passwor
plete access to it. I want
> to do this: "Encrypt the `.frm' file with a password. This option doesn't
do
> anything in the standard MySQL version. "
>
> (http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html) I have recompiled
> mysql to enable 64 indexes on a table.
l Message-
From: David Crane [mailto:[EMAIL PROTECTED]
Sent: 11 May 2004 18:21
To: [EMAIL PROTECTED]
Subject: Re: how do i encrypt the .frm file with a password
This will be distributed on Windows computers and not unix/linux.
""David Crane"" <[EMAIL PROTECTED]> wrote in mess
prevent users from being able
to
> simply copy the files and being able to have complete access to it. I want
> to do this: "Encrypt the `.frm' file with a password. This option doesn't
do
> anything in the standard MySQL version. "
>
> (http://dev.mysql.com/doc
At 12:45 -0400 5/11/04, David Crane wrote:
I need to provide some security to a database that I am working on. This
database will be distributed and I need to prevent users from being able to
simply copy the files and being able to have complete access to it. I want
to do this: "Encrypt the
n't access the table.
Kevin Cowley
R&D
Tel: 0118 902 9099 (direct line)
Email: [EMAIL PROTECTED]
Web: http://www.alchemetrics.co.uk
-Original Message-
From: David Crane [mailto:[EMAIL PROTECTED]
Sent: 11 May 2004 17:45
To: [EMAIL PROTECTED]
Subject: how do i encrypt the .frm fi
I need to provide some security to a database that I am working on. This
database will be distributed and I need to prevent users from being able to
simply copy the files and being able to have complete access to it. I want
to do this: "Encrypt the `.frm' file with a password. This opti
hing on the archives but
wanted to ask my question to the group.
I have a requirement to encrypt all data stored into a database. I was
wondering if there was a different way of doing this or should I use the
encrypt/decrypt functions?
The idea is that if someone stole the hard drive or comput
Paul DuBois wrote:
At 15:02 -0700 2/25/04, Colleen Dick wrote:
I'm sure this is in the manual somewhere or in the archives, but
I'm not finding it and I bet someone easily knows the short answer:
Using 3.23
setting a varchar field to PASSWORD("secret")
Having altered nothing regarding encryption i
At 15:02 -0700 2/25/04, Colleen Dick wrote:
I'm sure this is in the manual somewhere or in the archives, but
I'm not finding it and I bet someone easily knows the short answer:
Using 3.23
setting a varchar field to PASSWORD("secret")
Having altered nothing regarding encryption in the server
what is
I'm sure this is in the manual somewhere or in the archives, but
I'm not finding it and I bet someone easily knows the short answer:
Using 3.23
setting a varchar field to PASSWORD("secret")
Having altered nothing regarding encryption in the server
what is the default encryption type for PASSWORD?
c
Mike Koponick wrote:
The idea is that if someone stole the hard drive or computer, it would
be hard for someone to break into the database. It seems to me the best
way would be to encrypt the drive space, and use the login to
authenticate the encryption space on the hard drive.
How about sth like
Hello everyone,
I'm new to the list and did a little searching on the archives but
wanted to ask my question to the group.
I have a requirement to encrypt all data stored into a database. I was
wondering if there was a different way of doing this or should I use the
encrypt/decrypt func
I think your INSERT syntax is wrong. There is no "TABLE" in the syntax.
It has to be INSERT INTO admin VALUES .
- Shanta
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 2:03 PM
To: [EMAIL PROTECTED]
Subject: ENCRYPT Synt
, ensure the number of columns your inserting
match the schema of the table - if not explicitly specify the columns.
Regards,
Adam
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 3:03 PM
To: [EMAIL PROTECTED]
Subject: ENCRYPT Syntax problem
Dear list:
I`m trying to insert some values into my table but I received a error
message when I type::
INSERT INTO TABLE admin VALUES ('admin',ENCRYPT('system'),15,0);
The error said:
Error 1064: You have an error in SQL syntax.
Could someone help me to clarify th
At 01:57 PM 9/5/2003, you wrote:
This may be a weird question, but we were wondering if there was some sort
of way to encrypt or protect the database just in case of someone hacking
into the server it resides on. Since there might be some sensitive info in
the database, we'd like to go to as
This may be a weird question, but we were wondering if there was some sort
of way to encrypt or protect the database just in case of someone hacking
into the server it resides on. Since there might be some sensitive info in
the database, we'd like to go to as great a lengths as possible
Hi all,
Upon testing the "ENCRYPT" function of MySQL, [ eg. SELECT ENCRYPT("MyPass") ] I keep on getting "NULL" values. I read the online documentation on the site,
and they mentioned something about a specific "crypt" function that has to be on
Hi!
Is there any possible way to achieve mysql encrypt function work normaly on
windows?
I tried to compile mysql under cygwin but it didn't work.
thx,
Felho
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
While I found some information on this subject:
http://groups.google.com/groups?q=mysql+win32+encrypt&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=be3g14%24ulu%241%40FreeBSD.csie.NCTU.edu.tw&rnum=1
I can't make much sense of it.
Is there a *clear* way to have encrypt() cal
"GREEN, Darren" <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: US-ASCII, 48 lines --]
>
> I am running Discus Message Board on MYSQL server version 3.23.55 all on
> Windows 2K platform. Discus appears to be encrypting the user password
> w
Encrypt() using a system call to encrypt the string. So if your system
does not support crypt(), you are out of luck. Windows does not support
crypt().
How to get around this? Well, the best way to solve it is to install
linux on your PC. The easier one is to use another encrypting methods,
such
I am running Discus Message Board on MYSQL server version 3.23.55 all on
Windows 2K platform. Discus appears to be encrypting the user password
with, I think, Encrypt("password", "saltcode") (calling the function in
MYSQL). When I run it just returns NULL. Any
ideas why
Am Donnerstag, 4. Juli 2002 09:03 schrieben Sie:
> Your message cannot be posted because it appears to be either
> spam or simply off topic to our filter. To bypass the filter
> you must include one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and in
On ons, jul 03, 2002 at 11:00:19 +0200, Anders Gustafsson wrote:
> On Wed, Jul 03, 2002 at 08:06:52PM +0200, Tobias Bengtsson wrote:
>
> > I want to do transparent encryption. Like being able to choose an encryption
> > scheme of a table or database when created so that the data on disk is
> > al
On Wed, Jul 03, 2002 at 08:06:52PM +0200, Tobias Bengtsson wrote:
> I want to do transparent encryption. Like being able to choose an encryption
> scheme of a table or database when created so that the data on disk is
> always encrypted.
Why don't you just put the tables on an encrypted filesyst
Hi users and developers!
I deleted the in-reply-to header as everybody misunderstood my first mail.
Please give this a thought folks, especially developers, I can help developing
it if nessecary.
I want to do transparent encryption. Like being able to choose an encryption
scheme of a table or
At 05:40 AM 6/26/2002, you wrote:
>Hi!
>
>I want to store my mysqldatabase encrypted on disk, it contains sensitive
>data. Is there anybody out there doing this already? Or do I have to rewrite
>the myisam routines? Or is there another way?
>
>Regards, Tobbe
>
>-
Tobbe,
MySQL 4.02 has AE
Hi!
There is a workaround for it using ENCODE and DECODE functions.
Insert data in this style:
INSERT INTO t VALUES (field) ENCODE('string','password');
Retrive it using decode():
SELECT decode (field,'password') FROM t;
Perhaps this helps.
Tobias Bengtsson wrote:
> Hi!
>
> I want to st
Hi!
I want to store my mysqldatabase encrypted on disk, it contains sensitive
data. Is there anybody out there doing this already? Or do I have to rewrite
the myisam routines? Or is there another way?
Regards, Tobbe
--
`Given enough eyeballs, all bugs are shallow.'
69D6 E76A FC83 E9CA 0747 7A
ten
- Original Message -
From: "Al Caponi" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 7:18 AM
Subject: RE: encrypt password
> http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
>
> Using the PASSWORD funct
http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
Using the PASSWORD function is an irreversible process. Check the above
link.
A work around is you always deal with the encrypted password on the server
side.
E.g. When the user will login you encrypt the submitted password and do a
Hi ,
I am working in mysql . with the help of password() function I insert the
data in some table .
for example :-
insert into a values (password('name'));
when I fire select query . It shows me this -> 23e6065b74
I wants to decrypt the data again in same format as I insert with Select
query.
the password function can not be decrypted can it, `cuz i need to show the
users' pass to the sis adm therefore i am considering to use the
encode/decode functions, although i am not secure to use those functions, i
have read in somewhere its not so confident.
does anybody here have some experienc
: mysql_mailing List
Subject: Question about Encrypt function and Windows 2000 (Help a
Newbie!)
I am working on a password scheme, however I read in the MySql manual that
if encrypt isn't available, it will return a null set.
This is causing a problem with something I am working on us
I am working on a password scheme, however I read in the MySql manual that
if encrypt isn't available, it will return a null set.
This is causing a problem with something I am working on using a windows
2000 machine (with the recent version of MySql for windows platforms), is
there a si
t card numbers need to be stored in an
> encrypted form in a database (one-way encryption is preferred, in this
case).
> In order to do that, we use the MySQL ENCRYPT() function. From what I can
> reason, every encrypted DB string should be unique.
>
> However, even with only aroun
Warning
Could not process message with given Content-Type:
multipart/mixed; boundary="part3b7c1428c5479"
>>I am very new to the encrypt and decrypt data process and would like
to know how do I able to encrypt a string and store to MySQL and retrieve
the data and decrypt it at the later time.
Grab a copy of mcrypt (search http://freshmeat.net/ for it) and read
the docs for it -- its a goo
Thank you for all your valuable help and input. I now got some idea to do
the job. Greatly appreciated.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Michael Tam" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, August
a simple rotation of the ASCII alphabet by 13 places. i.e. A
becomes N, B becomes O, C becomes P, etc. The set wraps so that N becomes
A, O becomes B, etc. It's nice because the encrypt and decrypt functions
are exactly the same.
Rene
At 11:29 AM 8/14/01, you wrote:
>Hi all,
c example, but should give you some ideas on how it can
work.
Hope this helps,
>>On Tue, 14 Aug 2001 11:29:07 -0700, "Michael Tam" <[EMAIL PROTECTED]> wrote:
>>Hi all,
>>
>>I am very new to the encrypt and decrypt data process and would like to know ho
Hi all,
I am very new to the encrypt and decrypt data process and would like to know how
do I able to encrypt a string and store to MySQL and retrieve the data and decrypt it
at the later time.
I understood it sorts of contradict the point of security but I just want to use
it to
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 mac
Hello
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
Wouldn't that be a problem of your program? MySQL will sotre
anything and not care about what it is. You encrypt first, then
insert, next retrieve and decrypt.
Jason Whitlow schrieb am Mittwoch, 25. Juli 2001, 17:34:05:
> I hope this is not to stupid.
> I have looked at how to encr
So sprach »Christian Grimm« am 2001-07-25 um 22:16:04 +0200 :
> sa must be a 2-char long Salt-String...
Which is completely optional :)
sql,database,filter
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.
Sorry ---
How about this WITHOUT SELECT:
---
INSERT INTO Table VALUES(Lamer_ID, ENCRYPT("you are
lame...!","sa"));
---
uses the unix-cry
How about this:
---
INSERT INTO Table VALUES(Lamer_ID, SELECT ENCRYPT("you are
lame...!","sa"));
---
uses the unix-crypt()-function, means, its a One-Way-Crypt!
I hope this is not to stupid.
I have looked at how to encrypt strings in my database. I know that you need
to use a blob
and I think I can figure out how to encrypt from a query or SELECT but how
do I
encrypt on the INSERT.
Thanks for your help
Jason
tice that it says that "the first two characters represent the salt
> itself" when mentioning what constitutes the returned value.
>
> So, given this, you can consistently re-encrypt a string to compare
against
> the original by taking the first two characters and using them as
when mentioning what constitutes the returned value.
So, given this, you can consistently re-encrypt a string to compare against
the original by taking the first two characters and using them as the salt.
The example below demonstrates this.
mysql> select encrypt('bl
and how this could be usefull. I use
> encrypt to store password info in a database, but how do you compare the
> user entered password with the one in the database if the results vary
> the whole time? Please give me an application for this behaviour and I
> will be happy :-)
>
>
Ok, so you can obtain a random result (thought that was what random()
was for), but still cannot understand how this could be usefull. I use
encrypt to store password info in a database, but how do you compare the
user entered password with the one in the database if the results vary
the whole
On Thu, 7 Jun 2001, Richard Ellerbrock wrote:
> Looking at the encrypt function, it optionally takes a salt parameter. Using encrypt
>without specifying a salt yields random results:
>
> mysql> select encrypt('qwerty');
> +
Looking at the encrypt function, it optionally takes a salt parameter. Using encrypt
without specifying a salt yields random results:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1732533 to server version: 3.23.37-log
Type 'help;' or '\h&
100 matches
Mail list logo