Hi,
On Mon, Sep 20, 2010 at 4:59 AM, Tompkins Neil
wrote:
> Any ideas why my statement like SELECT SHA1('abc') AS my_sha is being
> returned as binary value, I thought it should be returning HEX in anycase ?
Maybe because that's what it's intended to do.
http://dev.mysql.com/doc/refman/5.1/en/en
Any ideas why my statement like SELECT SHA1('abc') AS my_sha is being
returned as binary value, I thought it should be returning HEX in anycase ?
I'm using MySQL community server 5.1.43, with Innodb tables.
Cheers
Neil
On Sat, Sep 18, 2010 at 10:43 AM, Johan De Meersman wrote:
> hex() and unhex
Simply base64-encode the returned binary string before offering it to your
client.
On Fri, Sep 17, 2010 at 1:22 PM, Tompkins Neil wrote:
> Hi,
>
> I need to encrypt a string like 'hello world', using a passkey. But I also
> need to be able to decrypt the encrypted phrase using the same passkey.
Hello,
Have you taken a look at:
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html
That might give you a good start.
Thanks,
Jimmy Guerrero
Sr Product Manager
MySQL, Inc
> -Original Message-
> From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED]
> Sent: Friday, Sept
On Oct 4, 2005, at 4:34 PM, Jeff Pflueger wrote:
Where might I find the key so that I can send it along to them? any
suggestions on this?
The password is what you need to send. The encryption and decryption
functions generate a key from the password. Internally, the key that
the AES/Ri
ah hah you are righht about the installationmysql -V shows 4.1
but the SHOW VARIABLES shows 3.something so something went wrong with
thhe update.
thanks for that.
Now if I encrypt using AES_ENCRYPT if I expect somebody else to decrypt
outside of mySQL I will need to provide the 'pass
Jeff Pflueger <[EMAIL PROTECTED]> wrote on 10/03/2005 03:46:09 PM:
> Hi,
> I need to encrypt data as I insert it into a mySQL database.
> The data will then be sent as a text file to another institution to be
> decrypted.
>
> I am using mySQL version 11.18 Distrib 3.23.58 for RedHat Linux.
>
> I
On May 21, 2004, at 5:19 AM, Victor Medina wrote:
| On May 21, 2004, at 1:54 AM, [EMAIL PROTECTED] wrote:
|
|> What level of Encryption does MySQL have? I cannot find much
security
|> information from mysql.com.
||
| http://dev.mysql.com/doc/mysql/en/Encryption_functions.html
|
Any level of SSL pr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greg Willits wrote:
| On May 21, 2004, at 1:54 AM, [EMAIL PROTECTED] wrote:
|
|> What level of Encryption does MySQL have? I cannot find much security
|> information from mysql.com.
|
|
| http://dev.mysql.com/doc/mysql/en/Encryption_functions.html
|
| -
On May 21, 2004, at 1:54 AM, [EMAIL PROTECTED] wrote:
What level of Encryption does MySQL have? I cannot find much security
information from mysql.com.
http://dev.mysql.com/doc/mysql/en/Encryption_functions.html
-- greg willits
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
TED]>, <[EMAIL PROTECTED]>
cc
Subject
Re: Encryption Issue
Hi,
- Original Message -
From: <[EMAIL PROTECTED]>
Sent: Sunday, February 22, 2004 3:18 PM
Subject: Re: Encryption Issue
> According to documentation there is a "query log" wich logs
established
&
Hi,
- Original Message -
From: <[EMAIL PROTECTED]>
Sent: Sunday, February 22, 2004 3:18 PM
Subject: Re: Encryption Issue
> According to documentation there is a "query log" wich logs
established
> connections and executed queries, also there is the "bi
ENCRYPT('information', 'key')
Any one who looks into the log file will be able to see the query, the
information and the key, and all my information would be compromised... am
i wrong?
Regards
FBR
Frederic Wenzel <[EMAIL PROTECTED]>
22/02/2004 05:21 a.m.
To
[EMA
[EMAIL PROTECTED] wrote:
I would like to encrypt informaton in MySQL DB using the "AES_ENCRYPT"
function, but what if someone looks into the log files?
What ever may be logged by the mysql daemon - I can't believe it loggs
passwords or the stored data itself. So why do you think so?
bye
Fred
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John Jolet wrote:
> I need to find out if it's possible to do two things with mysql.
> The first is external authentication, preferably with kerberos5, but
PAM will work as well.
No.
> Second, encrypting the data stream. Specifically with jdbc conn
On Fri, 2001-10-05 at 06:48, Manish Mehta wrote:
> hello,
>
> Is MySQL Support Encryption ?
>
Depends what yo mean. Database encryption? No. Use crypted filesystem
for this. Encryption functions? Partially yes. We have ENCRYPT() and
MD5() functions. Encrypted communication? Yes, from 4.0.0 MySQ
nal Message-
> From: Jeremy Falcon <[EMAIL PROTECTED]>
> To: Elizabeth Alderton <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
> <[EMAIL PROTECTED]>
> Date: 22 August 2001 20:26
> Subject: Re: Encryption of Data
>
>
> >What do you mean by "bring data dow
Elizabeth
> -Original Message-
> From: Jeremy Falcon <[EMAIL PROTECTED]>
> To: Elizabeth Alderton <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
> <[EMAIL PROTECTED]>
> Date: 22 August 2001 20:26
> Subject: Re: Encryption of Data
>
>
> >What do you me
esting cron - can you tell me what it is?
>
> Regards
>
> Elizabeth
> -Original Message-
> From: Jeremy Falcon <[EMAIL PROTECTED]>
> To: Elizabeth Alderton <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
> <[EMAIL PROTECTED]>
> Date: 22 August 2001 20:26
>
Jeremy Falcon schrieb am Donnerstag, 23. August 2001, 21:46:02:
> Contact your ISP and ask them if they already have and/or willing to set-up
> something for you.
Yes, there are always many ways to do things - but before I give
another, I'd really like to hear about the kind of task at hand
Contact your ISP and ask them if they already have and/or are willing to
set-up something for you. Here's an instance. One host I have used before
is TierraNet. They use cron to run a CGI script, named crontask.cgi, at
3AM. You can put anything you want to in that script (Perl, C/C++, etc.) to
Elizabeth Alderton schrieb am Donnerstag, 23. August 2001, 09:44:36:
> Thanks for suggesting cron - can you tell me what it is?
cron is a program on Linux to run scheduled programs. So you
write a program and tell cron to execute it in any kind of
interval you can think of. I don't know if you
t;
Date: 22 August 2001 20:26
Subject: Re: Encryption of Data
>What do you mean by "bring data down?" Would this be over a network? If
>so, what OS would the other machine be running? I'll assume it's Unix
>because that's my favorite. Seeing that mysql prints t
What do you mean by "bring data down?" Would this be over a network? If
so, what OS would the other machine be running? I'll assume it's Unix
because that's my favorite. Seeing that mysql prints to STDOUT you could
write a script to interface with MySQL, get the output, encrypt it, and then
se
Elizabeth Alderton schrieb am Mittwoch, 22. August 2001, 17:00:53:
> If I do a SELECT query to bring data down to a PC (this is
> being done through Delphi) how can I encrypt the data so that
> it comes safely?
> Equally when doing UPDATE and INSERT in the other direction I
> would want to enc
fractals wrote:
> I have to deploy a java GUI to a remote MySQL server. The GUI part is OK,
> but now I have some concerns about security issues, like: how could the
> conduit between the GUI and the database be secured (possibly encrypted) ? I
> think one solution would be to use SSL, but that i
26 matches
Mail list logo
