Tusaha Maqaalka
hadda la rakibayCWP Control Panel, laakiin waxay rabaan inay abuuraandatabase MySQL, haddana illoobayMySQLKalsoonida sirta ah ee database database, 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
u tag phpMyAdmin -> "Account"Tab:
- 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-kaagu isticmaaloWordPressSi aad u dhisto, fadlan wax ka beddel erayga sirta ah ee kaydka xogta ee faylka wp-config.php.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) la wadaagay "Maxaan sameeyaa haddii aan iloobo erayga sirta ah ee MySQL? CWP dib u deji/wax ka beddel habka erayga sirta ah ee isticmaalaha MySQL", way ku caawin doontaa.
Ku soo dhawoow inaad wadaagto xiriirka maqaalkan:https://www.chenweiliang.com/cwl-156.html