Ungachinja sei MySQL midzi mushandisi password ne terminal

Ini ndoziva mumwe maneja uyo akanganwa password yeiyo mudzi weMySQL, izvi zvinogona kuva kunetsekana chaiko, handiti?

Fungidzira kuti iwe unofanirwa kugadzira dhatabhesi nyowani, ita chero chinhu uye haugone nekuti haugone kurangarira password yemutungamiri (mudzi) weiyo MySQL server, iri dambudziko chairo.

Pano ini ndinokuratidza maitiro ekuwana iyo MySQL server kuburikidza neiyo terminal PASI yekumisikidza mudzi password, kuitira kuti kana uchinge uri mukati iwe unogona kushandura iyo midzi password.

Nyaya inoenderana:

Tarisa matafura e database yeMySQL uye gadzirisa huori

Chinhu chekutanga chichava kumisa mysql sevhisi:

service mysql stop

Izvi zvakamisa sevhisi, ikozvino tichaitanga asi neimwe nzira, nzira isingazotibvunze isu password gare gare:

mysqld_safe --skip-grant-tables &

Takagadzirira, ikozvino ngatitorei iyo MySQL terminal:

mysql -u root

Vachaona kuti haina kukumbira password, ivo vanozoona kuti vatopinda muMySQL koni kana terminal uye vanogona kuita chero chavanoda, ngatirambei tichichinja iyo MySQL midzi password.

Kutanga isu tinopinda iyo MySQL dhatabhesi seizvi:

use mysql;

Ipapo, ngatichinjei password:

update user set password=PASSWORD("ElNuevoPassword") where user='root';

Zvino ngativandudzei maropafadzo:

flush privileges;

Uye pakupedzisira tinobuda:

quit;

Ready, isu tachinja password yeiyo MySQL midzi mushandisi, ikozvino tava kuzomisa sevhisi uye titange sezvazvinofanira kuve:

service mysql stop

service mysql start

Fin

Izvi zvese, ivo vatangazve kutonga kwavo vega MySQL server