List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:August 17 1999 2:01pm
Subject:Re: mysql root password
View as plain text  
On Tue, 1999-08-17 09:42:12 -0400, Raymond Wong wrote:
> Is there a way to reset the root password?
> I lost it and can't remember what it was.

Are you the admin of the MySQL server?  Then just restart it with the
option --skip-grant-tables (or in short -Sg), now change the root
password, then restart the server again normally.

This should work.  (untested myself)

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
mysql root passwordRaymond Wong17 Aug
  • Re: mysql root passwordMartin Ramsch17 Aug