Tusitusiga Tusitusiga
Ua ou fa'ato'a fa'apipi'iina le CWP control panel , ae ou te fia faia se MySQL database , ae ua galo ia te a'u le upu fa'alilolilo o le MySQL database. O le a se mea e tatau ona ou faia?
Aua e te popole, afai e te manao e siaki lau upu faataga, faamolemole mulimuli i faatonuga o loo i lalo.
Va'ai MySQL root user password method
E mafai ona e faʻaogaina lenei faʻatonuga mai le atigi e matamata ai i le MySQL root user password:
grep password /root/.my.cnf
O le a se mea e tatau ona ou faia pe a galo ia te aʻu le MySQL root password o le CWP?
- O le MySQL root password e mafai ona toe setiina e ala i le ulufale i le SSH poloaiga.
Ina ia toe setiina le MySQL root password, ulufale i le poloaiga lenei e ala i le SSH:
sh /usr/local/cwpsrv/htdocs/resources/scripts/mysql_pwd_reset
Afai e te ulufale i le CWP control panel command e toe setiina le MySQL root password, e le mafai ona e sainiphpMyAdmin,E faapefea ona fai?
- Fa'aaoga le SSH fa'asoa fa'asoa i lenei tusiga e toe setiina ai le MySQL root password e aunoa ma le fa'aogaina o mataitusi fa'apitoa.
- Toe setiina le MySQL root password e faʻaaoga ai le faʻafefiloi o mataitusi tetele ma mataitusi laiti ma numera.
- A leai, e ono tupu ni mea sese, e taofia ai le saini i le CWP control panel ma le phpMyAdmin control panel.
Faamolemole taumafai e toe setiina le MySQL root password ma le poloaiga lenei:
sh /scripts/mysql_pwd_reset
CWP fesuia'i MySQL fa'aoga upu fa'aoga
Alu i le phpMyAdmin -> tab "Teugatupe" :
- Kiliki i luga ole tagata fa'aoga a'a"fa'atonu fa'atonu" ▼
- alu i le"suia le upu faataga"Vaega -> Fa'atupu Fa'amatalaga Fou ▼
- ona kiliki lea"fa'atino (Alu)” faamau ▲
Ole taimi nei e te mana'omia le setiina o se fa'aupuga fou ile faila fa'amaumauga o fa'amaumauga a lau 'upega tafa'ilagi.
Afai o lau upega tafaʻilagi e faʻaaoga ai le WordPress , faʻamolemole sui le upu faʻalilolilo o le faʻamaumauga o loʻo i totonu o le faila wp-config.php.
Fa'amoemoe o le a fesoasoani ia te oe le tusiga "O le a le mea e fai pe a galo ia te oe lau upu faataga o le MySQL root? Metotia CWP e toe seti/suia ai le upu faataga a le tagata fa'aoga MySQL" o lo'o fa'asoa i le blog a Chen Weiliang ( https://www.chenweiliang.com/ ).
Fa'asoa atu le so'otaga o lenei tusiga: https://www.chenweiliang.com/cwl-156.html