Skilled Gaming

Gaming => Metin2 => Jocuri/Games => Tutoriale/Tutorials => Topic started by: sssx on 21 July 2015, 06:20:11

Title: [TUT] Resetare parola SQL root in Free BSD
Post by: sssx 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ă.