Ungayitshintsha njani iphasiwedi yomsebenzisi we-MySQL ngesiphelo

Ndiyamazi omnye umlawuli olibeleyo igama eligqithisiweyo lengcambu ye-MySQL, oku kunokuba sisiphazamiso sokwenene, akunjalo?

Khawufane ucinge ukuba ufuna ukwenza idathabheyisi entsha, wenze nantoni na kwaye awukwazi kuba awuyikhumbuli iphasiwedi yomlawuli (ingcambu) yeseva ye-MySQL, ingxaki yokwenyani.

Apha ndiza kukubonisa indlela yokufikelela kwiserver ye-MySQL kwisiphelo sendlela NGAPHANDLE kokusetha igama eligqithisiweyo lengcambu, ukuze kuthi nje ngaphakathi ungatshintsha iphasiwedi yengcambu.

Inqaku elidibeneyo:

Jonga iitafile zedatha ye-MySQL kwaye ulungise ukonakala

Into yokuqala iya kuba kukumisa inkonzo ye-mysql:

service mysql stop

Oku kumise inkonzo, ngoku siza kuyiqala kodwa ngendlela eyahlukileyo, indlela eya kuthi ingasibuzi iphasiwedi kamva:

mysqld_safe --skip-grant-tables &

Silungile, ngoku masingene kwisiphelo sendlela ye-MySQL:

mysql -u root

Baza kubona ukuba khange ibuze iphasiwedi, baya kubona ukuba sele bengenile kwikhonsoli ye-MySQL okanye i-terminal kwaye banokwenza nantoni na abayifunayo, masiqhubeke nokutshintsha iphasiwedi yengcambu ye-MySQL.

Kuqala siza kungena kwisiseko sedatha ye-MySQL ngolu hlobo:

use mysql;

Emva koko, masitshintshe iphasiwedi:

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

Ngoku masivuselele amalungelo:

flush privileges;

Kwaye ekugqibeleni siyaphuma:

quit;

Silungile, siyitshintshe iphasiwedi yomsebenzisi wengcambu ye-MySQL, ngoku siza kuyeka inkonzo kwaye siyiqale njengoko kufanelekile:

service mysql stop

service mysql start

Ekupheleni

Konke oku, baphinde bafumana ulawulo lwe-MySQL server yabo