Littafin Adireshi
kawai shigarCibiyar Kula da CWP, amma son ƙirƙirarMySQL database, sake mantawaMySQLKalmar sirrin bayanan bayanai, me zan yi?
Kar ku damu, idan kuna son bincika kalmar sirrinku, da fatan za a bi umarnin da ke ƙasa.
Duba hanyar kalmar sirri ta tushen mai amfani MySQL
Kuna iya amfani da wannan umarni daga harsashi don duba kalmar sirrin mai amfani ta MySQL:
grep password /root/.my.cnf
Menene zan yi idan na manta kalmar sirrin MySQL na CWP?
- Za a iya sake saita kalmar sirri ta MySQL ta shigar da umarnin SSH.
Don sake saita kalmar sirri ta MySQL, shigar da umarni mai zuwa ta hanyar SSH:
sh /usr/local/cwpsrv/htdocs/resources/scripts/mysql_pwd_reset
Idan kun shigar da umarnin kwamiti na CWP don sake saita kalmar sirri ta MySQL, ba za ku iya shiga baphpMyAdmin, abin yi?
- Yi amfani da umarnin SSH da aka raba a cikin wannan labarin don sake saita kalmar sirri ta MySQL ba tare da amfani da haruffa na musamman ba.
- Sake saita tushen kalmar sirri ta MySQL ta amfani da gauraya manyan haruffa da lambobi.
- In ba haka ba, kurakurai na iya faruwa, hana shiga zuwa CWP iko panel da phpMyAdmin iko panel.
Da fatan za a gwada sake saita kalmar sirri ta MySQL tare da umarni mai zuwa:
sh /scripts/mysql_pwd_reset
CWP canza MySQL takamaiman kalmar sirrin mai amfani
Je zuwa phpMyAdmin -> "Account"Tab:
- Danna tushen mai amfani"edit izin" ▼
- Je zuwa"canza kalmar shiga"Sashe -> Ƙirƙirar Sabuwar Kalmar wucewa ▼
- sai ka danna"kashe (Go)” button ▲
Yanzu kuna buƙatar saita sabon kalmar sirri a cikin fayil ɗin daidaita bayanai na gidan yanar gizon ku.
Idan gidan yanar gizon ku yana amfaniWordPressDon ginawa, da fatan za a canza kalmar sirri ta bayanai a cikin fayil ɗin wp-config.php.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) shared "Me zan yi idan na manta da MySQL tushen kalmar sirri? CWP sake saiti/gyara hanyar kalmar sirri ta mai amfani MySQL", zai taimaka muku.
Barka da zuwa raba hanyar haɗin wannan labarin:https://www.chenweiliang.com/cwl-156.html
Barka da zuwa tashar Telegram na Chen Weiliang's blog don samun sabbin abubuwa!
📚 Wannan jagorar ya ƙunshi ƙima mai yawa, 🌟Wannan dama ce da ba kasafai ba, kar a rasa ta! ⏰⌛💨
Share da like idan kuna so!
Rarraba ku da abubuwan so sune ci gaba da ƙarfafa mu!