[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: retrieving data when it is encrypted using PASSWORD option?

To: <mysql@xxxxxxxxxxxxxxx>, "Irawan" <irawan1@xxxxxxxx>
Subject: Re: retrieving data when it is encrypted using PASSWORD option?
From: "Jonothan Farr" <jfarr@xxxxxxxx>
Date: Fri, 9 Mar 2001 20:27:24 -0800
List-help: <mailto:mysql-help@lists.mysql.com>
List-id: <mysql.mysql.com>
List-post: <mailto:mysql@lists.mysql.com>
List-subscribe: <mailto:mysql-subscribe@lists.mysql.com>
List-unsubscribe: <mailto:mysql-unsubscribe-treed=ultraviolet.org@lists.mysql.com>
Mailing-list: contact mysql-help@xxxxxxxxxxxxxxx; run by ezmlm (http://www.ezmlm.org)
References: <4.3.2.7.2.20010309220817.00b166e0@mail>

> the table was 
> created with the pwd as a VARCHAR(15)  <--- will this long enough to held 
> the encrypted password??

There's your problem. PASSWORD() returns a CHAR(16).

--jfarr



---------------------------------------------------------------------
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 <mysql-thread67857@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

References:
- retrieving data when it is encrypted using PASSWORD option?
  - From: Irawan

Prev by Date: retrieving data when it is encrypted using PASSWORD option?
Next by Date: Re: Uploading CSV.txt data to online table..
Previous by thread: retrieving data when it is encrypted using PASSWORD option?
Next by thread: error 127 from table header !!!
Index(es):
- Date
- Thread

This mailing list archive is a service of Copilot Consulting.