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 https://order.mysql.com/
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 f
hi, Mike.
What do this using an encrypted loopback-device, on which the
/var/lib/mysql stuff resides.
just check "man losetup" for instructions.
i'm NOT sure about the preformance issues, though.
and i am very concerned about filesystem-corruptionby my logic,
there's a double risk, since the
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
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 Syntax problem
I
First, don't use the word "table" in an insert into statement (e.g. `INSERT
INTO tbl_nm (col_1, col_2, col_3) VALUES ('a', 'b', 3)` where tbl_nm is the
name of a table in the database and col_1, col_2, etc. are names of columns
in the specified table). Second, ensure the number of columns your inse
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 great
"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
> with, I think, Encrypt("password", "s
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 a
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
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
SELEC
On Thursday 16 August 2001 12:42, Martin Bassie wrote:
> This is a multi-part message in MIME format.
>
> --part3b7c1428c5479
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Hi,
>
> We're working on system where credit card numbers need to be stored in
>>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 good idea t
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
If all you're looking for is a trivial hiding of the data, then I'd
suggest doing a rot13 on the string. I highly doubt there is a native
SQL function that does this, so you'll need to write your own function
in whatever interface you're using. Perl/PHP/whatever.
Rot13 is a simple rotation of
Michael,
I just did something like this, and used the ENCODE/DECODE. Works well.
Basically you want to assign a "special key" for the encoding/decoding of the
data you want to encode/decode. The column type should be either a BLOB or
TINYBOLD, as it's stored in a binary format, depend on the siz
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
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
Just use the password() function, which will return a nice 16-byte 1-way encrypted
string.
On Fri, 08 Jun 2001 00:04:18 -0700
Richard Ellerbrock <[EMAIL PROTECTED]> wrote:
> Ok, so you can obtain a random result (thought that was what random()
> was for), but still cannot understand how this co
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 tim
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');
> +---+
> | encrypt('qwerty') |
> +---+
> |
27 matches
Mail list logo
