Isalathiso senqaku
Isanda kufakwaIphaneli yokulawula yeCWP, kodwa ufuna ukwenzaMySQL database, ndalibala kwakhonaMySQLIgama lokugqithisa leDatabase, kufuneka ndenze ntoni?
Sukuxhala, ukuba ufuna ukujonga igama eliyimfihlo, landela le miyalelo ingezantsi.
Jonga indlela yegama lokugqitha lengcambu yeMySQL
Ungasebenzisa lo myalelo kwiqokobhe ukujonga igama eligqithisiweyo lomsebenzisi le-MySQL:
grep password /root/.my.cnf
Ndingenza ntoni ukuba ndilibele igama eligqithisiweyo le-MySQL le-CWP?
- Unokwenza kwakhona igama eligqithisiweyo le-MySQL lengcambu ngokufaka umyalelo we-SSH.
Ukusetha kwakhona igama eligqithisiweyo le-MySQL, ngenisa lo myalelo ulandelayo nge-SSH:
sh /usr/local/cwpsrv/htdocs/resources/scripts/mysql_pwd_reset
Ukuba awukwazi ukungena emva kokufaka umyalelo wokusetha kwakhona igama eligqithisiweyo le-MySQL kwiphaneli yokulawula ye-CWPphpMyAdmin,Kwenzeka njani?
- Sebenzisa umyalelo we-SSH ekwabelwana ngawo kweli nqaku ukuseta kwakhona igama eligqithisiweyo lengcambu ye-MySQL Musa ukusebenzisa iimpawu ezikhethekileyo.
- Seta kwakhona igama eligqithisiweyo lengcambu yeMySQL usebenzisa oonobumba abaxubeneyo besiNgesi kunye namanani.
- Ngaphandle koko, impazamo ingenzeka, ibangele ukungakwazi ukungena kwipaneli yokulawula ye-CWP kunye nephaneli yokulawula yephpMyAdmin.
Nceda uzame ukuseta kwakhona igama eligqithisiweyo lengcambu yeMySQL kwakhona usebenzisa lo myalelo ulandelayo:
sh /scripts/mysql_pwd_reset
I-CWP itshintsha i-MySQL yomsebenzisi ogqithisiweyo ochaziweyo
Yiya e phpMyAdmin -> "Iakhawunti"Ithebhu:
- Cofa kwingcambu yomsebenzisi"Hlengahlengisa iimvume" ▼
- Yiya e"Tshintsha iphasiwedi"Icandelo –> Yenza Igama Lokugqithisa Elitsha ▼
- emva koko ucofe"Phumeza (Hamba)” iqhosha ▲
Ngoku kufuneka usete igama eligqithisiweyo elitsha kwifayile yoqwalaselo yedatha yewebhusayithi.
Ukuba iwebhusayithi yakho iyasebenzaWordPressUkwakha, nceda uguqule igama eligqithisiweyo lesiseko kwifayile ye-wp-config.php.
Ndiyathemba Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kwabelwana "Ndingenza ntoni ukuba ndilibele igama eligqithisiweyo lengcambu yeMySQL?" CWP Ukuseta kwakhona / Guqula iMySQL yeNdlela yoMsebenzisi wePassword" iya kuba luncedo kuwe.
Wamkelekile ukwabelana ngekhonkco leli nqaku:https://www.chenweiliang.com/cwl-156.html