[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Cracking MySQL Passwords

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