Cracking MySQL Passwords

[Drew Tomlinson]

On 2/2/2006 4:40 PM Peter Giessel wrote:

>On Thursday, February 02, 2006, at 03:24PM, Drew Tomlinson <drew at mykitchentable.net> wrote:
>
>  
>
>>I'm frantically trying to recreate 3 users in the mysql.user table after 
>>accidentally deleting them.  I have the names and the password hashes 
>>but don't know the password.
>>    
>>
>
>Recreate then users with a different password then login to mysql as root and:
>
>use mysql;
>
>update user set Password="<password hash>" where User="<recreated user>";
>
>flush privaleges;
>
>  
>
Thank you very much.  That should work!

Drew

-- 
Visit The Alchemist's Warehouse
Magic Tricks, DVDs, Videos, Books, & More!

http://www.alchemistswarehouse.com