Tsab ntawv teev npe
nyuam qhuav ntsiaCWP Control Vaj Huam Sib Luag, tab sis xav tsimMySQL database, tsis nco qab lawmMySQLDatabase password password, kuv yuav ua li cas?
Tsis txhob txhawj, yog tias koj xav tshawb xyuas koj tus password, thov ua raws li cov lus qhia hauv qab no.
Saib MySQL root user password method
Koj tuaj yeem siv cov lus txib no los ntawm lub plhaub los saib MySQL hauv paus tus neeg siv lo lus zais:
grep password /root/.my.cnf
Kuv yuav ua li cas yog tias kuv tsis nco qab MySQL root password ntawm CWP?
- MySQL root password tuaj yeem rov pib dua los ntawm kev nkag mus rau SSH cov lus txib.
Txhawm rau rov pib dua MySQL root password, nkag mus rau cov lus txib hauv qab no ntawm SSH:
sh /usr/local/cwpsrv/htdocs/resources/scripts/mysql_pwd_reset
Yog tias koj nkag mus rau CWP tswj vaj huam sib luag hais kom rov pib dua MySQL hauv paus lo lus zais, koj tsis tuaj yeem nkag musphpmyadminYuav ua li cas?
- Siv cov lus txib SSH qhia hauv kab lus no kom rov pib dua MySQL hauv paus lo lus zais yam tsis siv cov cim tshwj xeeb.
- Rov pib dua MySQL hauv paus lo lus zais siv kev sib xyaw ntawm cov tsiaj ntawv loj thiab cov tsiaj ntawv me thiab cov lej.
- Txwv tsis pub, qhov yuam kev yuav tshwm sim, tiv thaiv kev nkag mus rau CWP tswj vaj huam sib luag thiab phpMyAdmin tswj vaj huam sib luag.
Thov sim rov pib dua MySQL root password dua nrog cov lus txib hauv qab no:
sh /scripts/mysql_pwd_reset
CWP hloov MySQL teev tus neeg siv tus password
mus rau phpmyadmin -> "Account"Tab:
- Nyem rau ntawm tus neeg siv hauv paus"edit permission" ▼
- mus rau"hloov Password"Tshooj -> Tsim Tus password tshiab ▼
- ces nyem"execute (mus)” khawm ▲
Tam sim no koj yuav tsum tau teeb tsa tus password tshiab hauv koj lub vev xaib database configuration file.
Yog tias koj lub vev xaib sivWordPressTxhawm rau tsim, thov hloov tus password database hauv wp-config.php cov ntaub ntawv.
Cia siab Chen Weiliang Blog ( https://www.chenweiliang.com/ ) qhia "Kuv yuav ua li cas yog tias kuv tsis nco qab MySQL root password? CWP pib dua / hloov kho MySQL tus neeg siv tus password txoj kev", nws yuav pab tau koj.
Zoo siab txais tos los qhia qhov txuas ntawm kab lus no:https://www.chenweiliang.com/cwl-156.html