Re: password / last record
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
password / last record
sql, query Hello Folks 1. Is there anyway to know the string value of the password using the encrypted value , from the mysql.user table ? 2. How can I know the most recently entered record, that does not have an AUTOINCREMENT column ? Thanks for the tips. - 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
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