[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
 
[an error occurred while processing this directive] [an error occurred while processing this directive]
Skåne Sjælland Linux User Group - http://www.sslug.dk Home   Subscribe   Mail Archive   Forum   Calendar   Search
MhonArc Date: [Date Prev] [Date Index] [Date Next]   Thread: [Date Prev] [Thread Index] [Date Next]   MhonArc
 

Re: [NOVICE] glemt pw til MySQL



Den 11-01-2004 kl 00:52 skrev David List:

>On Sat, 10 Jan 2004 21:31:53 +0100,
>Bjørn Fahnøe <sslug@sslug>
>wrote in <sslug@sslug>:
>> Jeg har glemt mit password og måske også administratornavn til MySQL.
>> Jeg har ikke brugt det længe, men et par programmer bruger det så jeg
>kan ikke bare reinstallere.
>> Kan jeg gøre noget, det er jo på min egen maskine
>
>Jeg havde selvsamme problem for faa dage siden. Genstart MySQL med
>--skip-grant-tables option (indsaet det evt. midlertidigt i linien i
>/etc/init.d/mysql eller hvad du nu bruger til at start MySQL), udsted
>foelgende:
># mysql -h localhost mysql
>og ret i tabellen 'user':
>
>mysql> update user set password=password('det_ny_password') where
>> user='root' and host='localhost';
>mysql> flush priviliges;
>
>Erstat det_ny_password med dit oenskede password.
>Den sidste query genindlaeser brugernes privilegier. Saa vidt jeg ved
>behoever du ikke genstarte MySQL efter dette, men det gjorde jeg dog
>selv (husk at fjerne --skip-grant-tables option foerst, hvis du har
>indsat det i startup scriptet).
>
>--
>Med venlig hilsen / Best regards
>David List
>
>sslug-novice: Listen for begynder-relaterede spørgsmål

*********** Citat slut  ***********
Det lyder rigtigt og det står også i manualen, men jeg får unrecognizable option
Bjørn



 
Home   Subscribe   Mail Archive   Index   Calendar   Search

 
 
Questions about the web-pages to <www_admin>. Last modified 2005-08-10, 21:16 CEST [an error occurred while processing this directive]
This page is maintained by [an error occurred while processing this directive]MHonArc [an error occurred while processing this directive] # [an error occurred while processing this directive] *