Author Topic:  [TUT] Resetare parola SQL root in Free BSD  (Read 1198 times)

0 Members and 1 Guest are viewing this topic.

Offline sssx

  • ◄ S E N Z A Ţ I O N A L ►
  • Hero Member
  • *
  • Posts: 844
  • Reputation: 4
  • Gender: Male
  • MAK3M3FAD3###
[TUT] Resetare parola SQL root in Free BSD
« on: 21 July 2015, 06:20:11 »
Se pune în /etc/rc.conf :
[pawn]mysql_args=”–skip-grant-tables –skip-networking”[/pawn]

Pe urmă:
Code:
[pawn]/usr/local/etc/rc.d/mysql-server restart[/pawn]

Apoi:
Code:
[pawn]mysql -u root mysql[/pawn]
 
Code:
[pawn]UPDATE user SET Password=PASSWORD(‘Parola Noua’) WHERE USER=’root’;[/pawn]
 
Code:
[pawn]FLUSH PRIVILEGES;[/pawn]
 
Code:
[pawn]exit;[/pawn]

După se scoate din /etc/rc.conf linia:
Code:
[pawn]mysql_args=”–skip-grant-tables –skip-networking”[/pawn]

Şi se dă restart la mysql !
Code:
[pawn]/usr/local/etc/rc.d/mysql-server restart[/pawn]
 
Apoi parola dvs. de root va fi resetată.







 

SimplePortal 2.3.7 © 2008-2024, SimplePortal