Tusaha Maqaalka
Waxaan hadda rakibay guddiga xakamaynta CWP , laakiin waxaan rabaa inaan sameeyo keydka xogta MySQL , laakiin waxaan illoobay erayga sirta ah ee keydka xogta MySQL . Maxaan sameeyaa?
Ha werwerin, haddii aad rabto inaad hubiso eraygaaga sirta ah, fadlan raac tilmaamaha hoose.
Arag MySQL habka erayga sirta ah ee isticmaalaha
Waxaad ka isticmaali kartaa amarkan qolofka si aad u aragto erayga sirta ah ee isticmaalaha MySQL:
grep password /root/.my.cnf
Maxaan sameeyaa haddii aan illoobo erayga sirta ah ee MySQL ee CWP?
- Kalsoonida xididka MySQL dib ayaa loo dajin karaa iyadoo la geliyo amarka SSH.
Si aad dib ugu dejiso erayga sirta ah ee MySQL, geli taliska soo socda adoo isticmaalaya SSH:
sh /usr/local/cwpsrv/htdocs/resources/scripts/mysql_pwd_reset
Haddii aad gasho taliska kontoroolka CWP si aad dib ugu dejiso erayga sirta ah ee MySQL, ma geli kartidphpMyAdminSidee loo sameeyaa?
- Isticmaal amarka SSH ee lagu wadaago maqaalkan si aad dib ugu dejiso erayga sirta ah ee MySQL adoon isticmaalin xarfo gaar ah.
- Dib u deji erayga sirta ah ee MySQL adoo isticmaalaya xarfo waaweyn iyo kuwo yaryar iyo tirooyin isku jira.
- Haddii kale, khaladaad ayaa dhici kara, ka hortagga gelitaanka guddiga xakamaynta CWP iyo phpMyAdmin kontoroolka.
Fadlan isku day inaad dib u dejiso erayga sirta ah ee MySQL mar labaad adoo wata amarkan soo socda:
sh /scripts/mysql_pwd_reset
CWP wax ka beddel MySQL sirta isticmaale ee cayiman
Tag phpMyAdmin -> tabka "Accounts" :
- Guji xididka isticmaalaha"wax ka beddel ogolaanshaha" ▼
- u tag"badalida Lambarka sirta ah"Qaybta -> Samee erayga sirta ah ee cusub ▼
- ka dibna dhagsii"fuli (tag)” badhanka v
Hadda waxaad u baahan tahay inaad dhigato furaha sirta ah ee cusub faylka qaabeynta xogta xogta ee degelkaaga.
Haddii website-kaaga lagu dhisay WordPress , fadlan wax ka beddel erayga sirta ah ee keydka xogta ee faylka wp-config.php.
Waxaan rajeynayaa in maqaalka "Maxaa la sameeyaa haddii aad illowdo eraygaaga sirta ah ee MySQL? Habka CWP ee dib loogu dejinayo/beddelayo erayga sirta ah ee isticmaalaha MySQL" ee lagu wadaagay baloogga Chen Weiliang ( https://www.chenweiliang.com/ ) uu ku caawin doono.
Xor ayaad u tahay inaad la wadaagto xiriirkan maqaalka: https://www.chenweiliang.com/cwl-156.html