[Wolves] Rebuilding MySQL user database

Jon Farmer jonfarmer at enta.net
Fri Apr 2 09:18:20 BST 2004


Old Dan wrote:
> Hi all
> 
> Does anyone know how to rebuild the MySQL users database, specifically 
> so root gets it's proper rights back?  I've been trying to install 
r.
> 
> So is there any way of getting it back, or am I going to have to purge? 

You restart the server with the --skip-grant-tables option .

This will let you in as user root with no password and then you just do a :-

update mysql.user set Password=PASSWORD(iwilltrytorememberthistime') 
where User = 'root';


Regards

Jon

-- 
Jon Farmer
Senior Systems Developer
Entanet International Ltd
Tel: +44 (0)1952 428969
Mob: +44 (0)7017 429590
SMS -> Email 07986200312 Prexif SMS With JF
www.enta.net




More information about the Wolves mailing list