Cracking MySQL Passwords

[Peter Giessel]

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;