Login

Statistici

Membri: 310
Stiri: 1507
Linkuri: 33
Vizitatori: 3579448

Sponsored links

Mirror MYLRo.org

Carti Linux direct de pe mirror-ul MYLRo.org
Advertisement
Reseteaza parola MySQL E-mail
  • Currently 4.0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Rating: 4.0/5 (4 votes cast)

Scris de Cypress   
Wednesday, 23 July 2008
Ti-ai uitat parola MySQL. No problem. Opreste serviciul MySQL cu

# /etc/init.d/mysql stop

...si reporneste-l fara parola

# mysqld_safe –skip-grant-tables &

Vei avea un output de genul

[1] 5958

Apasa Enter si tasteaza

# mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD(”NEW-ROOT-PASSWORD”) where User=’root’;
mysql> flush privileges;
mysql> quit

Restarteaza MySQL

# /etc/init.d/mysql restart
Comments
Add NewSearchRSS
Only registered users can write comments!

Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved.


Stiri similare:

 

Ultimele comentarii

Tips & Tricks

Scaneaza sectoarele stricate
Bad sectors... Sunt vanataile harddisc-ului. Pentru a verifica daca un drive se afla in stare buna de functionare, ne folosim de capabilitatile SMART ale acestuia:

smartctl -t long /dev/hda

Daca vrei sa scanezi si dupa sectoare stricate, foloseste

badblocks -sv /dev/hda
 

Vizitatori Online

Avem 1 vizitator si 1 membru online

Sponsored links