Tsab ntawv teev npe
Kuv nyuam qhuav teeb tsa CWP control panel , tab sis kuv xav tsim ib lub MySQL database , tab sis kuv tsis nco qab MySQL database password. Kuv yuav tsum 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 -> "Accounts" 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 koj lub vas sab hauv internet siv WordPress los tsim , thov hloov tus password ntawm lub database hauv cov ntaub ntawv wp-config.php.
Vam tias, tsab xov xwm "Yuav ua li cas yog tias koj tsis nco qab koj tus password MySQL root? CWP txoj kev los pib dua / hloov MySQL tus neeg siv password" uas tau muab faib rau Chen Weiliang lub blog ( https://www.chenweiliang.com/ ) yuav pab tau koj.
Xav qhia qhov txuas ntawm tsab xov xwm no: https://www.chenweiliang.com/cwl-156.html