Ungashintsha kanjani iphasiwedi yomsebenzisi we-MySQL nge-terminal

Ngiyamazi omunye umlawuli okhohliwe iphasiwedi yempande ye-MySQL, lokhu kungaba ukuphazamiseka kwangempela, akunjalo?

Cabanga ukuthi udinga ukudala i-database entsha, wenze noma yini futhi awukwazi ngoba awukwazi ukukhumbula iphasiwedi yomlawuli (impande) yeseva ye-MySQL, inkinga yangempela.

Lapha ngizokukhombisa ukuthi ungangena kanjani kuseva ye-MySQL ngokusebenzisa i-terminal NGAPHANDLE kokusetha iphasiwedi yempande, ukuze kuthi lapho ungaphakathi ukwazi ukushintsha iphasiwedi yempande.

I-athikili ehlobene:

Bheka Amathebula Esizinda sedatha ye-MySQL nokulungisa Konakele

Into yokuqala kuzoba ukumisa insiza ye-mysql:

service mysql stop

Lokhu kumise insiza, manje sizoqala kodwa ngendlela ehlukile, indlela engeke isasicela iphasiwedi ngokuhamba kwesikhathi:

mysqld_safe --skip-grant-tables &

Silungile, manje ake sifinyelele ukuphela kwe-MySQL:

mysql -u root

Bazobona ukuthi ayicelanga iphasiwedi, bazobona ukuthi sebevele bangene kukhonsoli ye-MySQL noma i-terminal futhi bangenza noma yini abayifunayo, ake siqhubeke nokushintsha iphasiwedi yempande ye-MySQL.

Okokuqala sizofaka i-database ye-MySQL kanjena:

use mysql;

Ngemuva kwalokho, ake sishintshe iphasiwedi:

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

Manje ake siqale kabusha amalungelo:

flush privileges;

Ekugcineni siyaphuma:

quit;

Silungile, siguqule iphasiwedi yomsebenzisi wezimpande ze-MySQL, manje sesizomisa insiza bese siyiyiqala njengoba kufanele:

service mysql stop

service mysql start

ekupheleni

Yilokhu, sebethole kabusha ukulawula kweseva yabo ye-MySQL