Uhla lwemibhalo ye-athikili
isanda kufakwaIphaneli yokulawula ye-CWP, kodwa ufuna ukudalaMySQL database, khohlwa futhiMySQLIphasiwedi yesizindalwazi, yini okufanele ngiyenze?
Ungakhathazeki, uma ufuna ukuhlola iphasiwedi yakho, sicela ulandele imiyalo engezansi.
Buka indlela yephasiwedi yomsebenzisi yezimpande ze-MySQL
Ungasebenzisa lo myalo kusuka kugobolondo ukuze ubuke iphasiwedi yomsebenzisi wempande ye-MySQL:
grep password /root/.my.cnf
Yini okufanele ngiyenze uma ngikhohlwa iphasiwedi yempande ye-MySQL ye-CWP?
- Iphasiwedi yempande ye-MySQL ingasethwa kabusha ngokufaka umyalo we-SSH.
Ukusetha kabusha iphasiwedi yempande ye-MySQL, faka umyalo olandelayo nge-SSH:
sh /usr/local/cwpsrv/htdocs/resources/scripts/mysql_pwd_reset
Uma ufaka umyalo wephaneli yokulawula ye-CWP ukuze usethe kabusha iphasiwedi yempande ye-MySQL, awukwazi ukungena ngemvumephpMyAdmin, Kwenziwa kanjani?
- Sebenzisa umyalo we-SSH owabiwe kulesi sihloko ukuze usethe kabusha iphasiwedi yempande ye-MySQL ngaphandle kokusebenzisa izinhlamvu ezikhethekile.
- Setha kabusha iphasiwedi yempande ye-MySQL usebenzisa ingxube yezinhlamvu nezinombolo ezinkulu nezincane.
- Uma kungenjalo, amaphutha angenzeka, avimbele ukungena kuphaneli yokulawula ye-CWP kanye nephaneli yokulawula ye-phpMyAdmin.
Sicela uzame ukusetha kabusha iphasiwedi yempande ye-MySQL futhi ngomyalo olandelayo:
sh /scripts/mysql_pwd_reset
I-CWP lungisa iphasiwedi yomsebenzisi ecacisiwe ye-MySQL
Iya ku phpMyAdmin -> "I-akhawunti"Ithebhu:
- Chofoza ku-root user's"hlela imvume" ▼
- Iya ku"SHINTSHA iphasiwedi"Isigaba -> Khiqiza Iphasiwedi Entsha ▼
- bese uchofoza"sebenzisa (Go)” inkinobho ▲
Manje udinga ukusetha iphasiwedi entsha kufayela lokucushwa lesizindalwazi sewebhusayithi yakho.
Uma iwebhusayithi yakho isebenzisaWordPressUkuze wakhe, sicela uguqule iphasiwedi yesizindalwazi kufayela le-wp-config.php.
I-Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) wabelane "Yini okufanele ngiyenze uma ngikhohlwa iphasiwedi yempande ye-MySQL? I-CWP setha kabusha/shintsha indlela yephasiwedi yomsebenzisi ye-MySQL", izokusiza.
Siyakwamukela ukwabelana ngesixhumanisi salesi sihloko:https://www.chenweiliang.com/cwl-156.html
Uyemukelwa esiteshini seTelegram sebhulogi ka-Chen Weiliang ukuze uthole izibuyekezo zakamuva!
📚 Lo mhlahlandlela uqukethe inani elikhulu, 🌟Leli ithuba eliyivelakancane, ungaphuthelwa! ⏰⌛💨
Yabelana futhi uthanda uma uthanda!
Ukwabelana kwakho nokuthanda kwakho kuyisisusa sethu esiqhubekayo!