Kalozera wa Nkhani
Ndangoyika kumene CWP control panel , koma ndikufuna kupanga database ya MySQL , koma ndaiwala mawu achinsinsi a database ya MySQL . Ndichite chiyani?
Osadandaula, ngati mukufuna kuwona mawu achinsinsi, chonde tsatirani malangizo omwe ali pansipa.
Onani njira yachinsinsi ya MySQL root user
Mungagwiritse ntchito lamulo ili kuchokera ku chipolopolo kuti muwone mawu achinsinsi achinsinsi a MySQL:
grep password /root/.my.cnf
Kodi nditani ndikayiwala chinsinsi cha MySQL cha CWP?
- Mawu achinsinsi a MySQL atha kukhazikitsidwanso mwa kulowa lamulo la SSH.
Kuti mukhazikitsenso mawu achinsinsi a MySQL, lowetsani lamulo lotsatirali kudzera pa SSH:
sh /usr/local/cwpsrv/htdocs/resources/scripts/mysql_pwd_reset
Ngati mulowetsa lamulo la gulu la CWP kuti mukhazikitsenso mawu achinsinsi a MySQL, simungathe kulowaphpMyAdmin, Kodi mungachite bwanji?
- Gwiritsani ntchito lamulo la SSH lomwe lagawidwa m'nkhaniyi kuti mukonzenso mawu achinsinsi a MySQL osagwiritsa ntchito zilembo zapadera.
- Bwezeretsani mawu achinsinsi a MySQL pogwiritsa ntchito zilembo zazikulu ndi zazing'ono ndi manambala.
- Kupanda kutero, zolakwika zitha kuchitika, kulepheretsa kulowa kwa CWP control panel ndi phpMyAdmin control panel.
Chonde yesani kukhazikitsanso password ya mizu ya MySQL ndi lamulo ili:
sh /scripts/mysql_pwd_reset
CWP sinthani mawu achinsinsi achinsinsi a MySQL
Pitani ku phpMyAdmin -> tabu ya "Akaunti" :
- Dinani pa root user's"edit permit" ▼
- kupita ku"Sinthani mawu achinsinsi"Gawo -> Pangani Mawu Achinsinsi Atsopano ▼
- kenako dinani"kuchita (Go)” batani ▲
Tsopano muyenera kuyika mawu achinsinsi atsopano mufayilo yanu yatsamba lawebusayiti.
Ngati tsamba lanu lawebusayiti lapangidwa pogwiritsa ntchito WordPress , chonde sinthani mawu achinsinsi a database mu fayilo ya wp-config.php.
Tikukhulupirira kuti nkhani yakuti "Choyenera kuchita ngati mwaiwala mawu achinsinsi anu a MySQL? Njira ya CWP yokonzanso/kusintha mawu achinsinsi a MySQL" yomwe yagawidwa pa blog ya Chen Weiliang ( https://www.chenweiliang.com/ ) idzakuthandizani.
Khalani omasuka kugawana ulalo wa nkhaniyi: https://www.chenweiliang.com/cwl-156.html