O le a se mea e tatau ona ou faia pe a galo ia te aʻu le password root MySQL? CWP toe setiina/suia MySQL auala upu faataga tagata faaaoga

faatoa fa'apipi'iCWP Pulea Vaega, ae manao e fatuMySQL database, toe galoMySQLPassword password database, o le a le 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 -> "Account"Tab:

  1. Kiliki i luga ole tagata fa'aoga a'a"fa'atonu fa'atonu"
    O le a se mea e tatau ona ou faia pe a galo ia te aʻu le password root MySQL? CWP toe setiina/suia MySQL auala upu faataga tagata faaaoga
  2. alu i le"suia le upu faataga"Vaega -> Fa'atupu Fa'amatalaga Fou ▼
    O le a se mea e tatau ona ou faia pe a galo ia te aʻu le password root MySQL? Ata 2 o le CWP toe setiina/suia MySQL user password method

  3. 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 loʻo faʻaogaina lau 'upega tafaʻilagiWordPressIna ia fausia, fa'amolemole sui le fa'amatalaga fa'amatalaga i le faila wp-config.php.

Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) faasoa "O le a se mea e tatau ona ou faia pe a galo ia te aʻu le password MySQL root? CWP reset/suia MySQL user password method", o le a fesoasoani ia te oe.

Fa'afeiloa'i e fa'asoa le so'otaga o lenei tusitusiga:https://www.chenweiliang.com/cwl-156.html

Faʻafeiloaʻi i le Telegram channel o le blog a Chen Weiliang e maua ai faʻamatalaga lata mai!

🔔 Ia avea oe ma tagata muamua e maua le taua "ChatGPT Content Marketing AI Tool Usage Guide" i le laina pito i luga o le lisi! 🌟
📚 O lenei taʻiala o loʻo i ai le taua tele, 🌟O se avanoa e seasea maua, aua le misia! ⏰⌛💨
Faasoa ma fiafia pe a e fiafia i ai!
O lau fefa'asoaa'i ma le fiafia o la matou fa'aosofiaga faifaipea!

 

发表 评论

O le a le faʻasalalauina lau tuatusi imeli. Faʻaoga fanua e manaʻomia * Igoa

tusi i luga