Cracking MySQL Passwords

Peter Giessel pgiessel at
Thu Feb 2 16:40:16 PST 2006

On Thursday, February 02, 2006, at 03:24PM, Drew Tomlinson <drew at> 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;

More information about the freebsd-questions mailing list