Hi Arjen
If that is the case, suppose if I have forgotten the string password of
a particular user But I want to grant certain privileges to him,
is
GRANT DELETE ,..... ON <Database Name> TO <User Name> IDENTIFIED BY
'<Encrypted Password>'
valid ?
regards
----- Original Message -----
From: "Arjen Lentz" <[EMAIL PROTECTED]>
To: "kayamboo" <[EMAIL PROTECTED]>
Cc: "list mysql" <[EMAIL PROTECTED]>
Sent: Thursday, October 10, 2002 1:08 PM
Subject: Re: password / last record
> Hi,
>
> On Thu, 2002-10-10 at 10:57, kayamboo wrote:
> > 1. Is there anyway to know the string value of the password using the
> > encrypted value , from the mysql.user table ?
>
> No. It's scrambled with a one-way (lossy) algorithm.
>
> > 2. How can I know the most recently entered record, that does not
have an
> > AUTOINCREMENT column ?
>
> You can't.
> Rows are by definition un-ordered in SQL databases, because storage is
> an internal matter for the server, it can do it any way it sees fit
> (it'll depend on the format, and other considerations like filling gaps
> of deleted rows, etc).
>
> The only logical ordering is one you put in (with AUTO_INCREMENT or
> timestamps or whatever). Actually you would only see that order if you
> use SELECT ... ORDER BY ... Otherwise, output is also unordered!
> (the fact that it may appear ordered while not using ORDER BY is purely
> coincidence: delete a row and insert a new one and you'll definitely
> find more disorder ;-)
>
>
> Regards,
> Arjen.
>
> --
> MySQL Training in Auckland and Sydney, http://www.mysql.com/training/
> Purchase Training, Support, Licenses @ https://order.mysql.com/?marl
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer
> /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia
> <___/ www.mysql.com
>
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
