Kalozera wa Nkhani
anangoikidwaCWP Control Panel, koma ndikufuna kupangaMySQL database, iwalaninsoMySQLAchinsinsi achinsinsi pa Database, nditani?
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
kupita ku phpMyAdmin -> "Akaunti"Tab:
- 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 likugwiritsa ntchitoWordPressKuti mumange, chonde sinthani mawu achinsinsi achinsinsi mu fayilo ya wp-config.php.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) adagawana "Kodi nditani ndikayiwala mawu achinsinsi a MySQL? CWP sinthani / sinthani njira yachinsinsi ya MySQL", ikuthandizani.
Takulandirani kugawana ulalo wa nkhaniyi:https://www.chenweiliang.com/cwl-156.html
Takulandilani panjira ya Telegraph yabulogu ya Chen Weiliang kuti mupeze zosintha zaposachedwa!
📚 Bukuli lili ndi phindu lalikulu, 🌟Uwu ndi mwayi wosowa, musaphonye! ⏰⌛💨
Share ndi like ngati mukufuna!
Kugawana kwanu ndi zomwe mumakonda ndizomwe zimatilimbikitsa nthawi zonse!