List:General Discussion« Previous MessageNext Message »
From:Ravi Raman Date:July 18 2001 2:17pm
Subject:RE: AW: password-recovery for root-user?
View as plain text  
>mysqld --skip-grant-tables

section 6.3 on this page:
http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h
tml

-ravi.



-----Original Message-----
From: Andy Tanner [mailto:andrew.tanner@stripped]
Sent: Wednesday, July 18, 2001 10:03 AM
To: Werner Stuerenburg; Rischbode, Horst
Cc: mysql@stripped
Subject: RE: AW: password-recovery for root-user?



 Similarly - how about

 - take a copy of you original mysql database tables
 - overwrite the mysql database tables with the original installation tables
 - login as root (the password will be blank)
 - import your orignial tables back into the mysql database

 good luck
 Andy

-----Original Message-----
From: Werner Stuerenburg [mailto:ws@stripped]
Sent: 18 July 2001 13:26
To: Rischbode, Horst
Cc: mysql@stripped
Subject: Re: AW: password-recovery for root-user?


You can reinstall the complete system from scratch, if you are
superuser to that system. Would be the easiest way to do it, I
guess.

> I'm trying to get the root-password to be deleted or set to a
> new value without knowing the old password. (Forgotten...)

table

--
Herzlich
Werner Stuerenburg

_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread79998@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-andrew.tanner=uk.worldpay.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread80002@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-ravi=webdream.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


Thread
AW: password-recovery for root-user?Horst Rischbode18 Jul
  • Re: password-recovery for root-user?T Halim18 Jul
  • Re: AW: password-recovery for root-user?Werner Stuerenburg18 Jul
    • RE: AW: password-recovery for root-user?Andy Tanner18 Jul
      • RE: AW: password-recovery for root-user?Ravi Raman18 Jul
        • Re[2]: AW: password-recovery for root-user?Werner Stuerenburg18 Jul
          • RE: Re[2]: AW: password-recovery for root-user?Ravi Raman18 Jul