phpMyAdmin ඩේටා බේස් වැඩ්ඩන්ට

[LajjaNathiBayya]

මචන්ලා අපේ ඔෆිස් එකට අපිට online web App එකක් design කරගත්ත 3rd party company එකකට කියලා... Corona එන්න කලින්.
ඒ APP එකේ අපෙ Office එකේ හැමෝටම User Name එකකුයි Password එකකුයි දීල තිබුනෙ අදාල වැඩේ කරන්න.
අඩාල APP එකේ Option එකක් දීල තිබුනෙ නෑ Password Reset කරන්න or Change කරන්න. අපි ඒ Option එක Request කරල තිබුනෙ.

උන් ඒක කරන්න කලින් Corona ආවා, ලොක් ඩවුන් උනා... කොහොම හරි Office eka back to normal තත්වයට එනකොට APP එක හදන්න දුන්නු Company එක closed. ඒකෙ වැඩ කරපු එවුනුත් නෑ

මට ඕනේ හෙල්ප් එක මේකයි... අඩාල web app එක හොස්ටින්ග් කරපු Site එකට මට Access තියනවා. මට එ phpMyAdmin ඩේටා බේස් එකත් ඔපෙන් කරන්න පුලුවන්. එත් මම කොහොමද User කෙනෙක්ගෙ Password eka Reset කරන්නෙ අදාල database එක ඔපෙන් කරලා.

ප්ලේසෙ හෙල්ප් මචන්ලා.

DB එක ඔපෙන් කරපුවාම මේවගේ

 

[හෙළයෙක්]

aluth account ekak hadapan oni password eka dala. ita pase eke hash eka okata dala aluth eka del kapan.

 

[LajjaNathiBayya]

aluth account ekak hadapan oni password eka dala. ita pase eke hash eka okata dala aluth eka del kapan.

ado sirada... ehe puluwandha

 

[elajani]

මචන්ලා අපේ ඔෆිස් එකට අපිට online web App එකක් design කරගත්ත 3rd party company එකකට කියලා... Corona එන්න කලින්.
ඒ APP එකේ අපෙ Office එකේ හැමෝටම User Name එකකුයි Password එකකුයි දීල තිබුනෙ අදාල වැඩේ කරන්න.
අඩාල APP එකේ Option එකක් දීල තිබුනෙ නෑ Password Reset කරන්න or Change කරන්න. අපි ඒ Option එක Request කරල තිබුනෙ.

උන් ඒක කරන්න කලින් Corona ආවා, ලොක් ඩවුන් උනා... කොහොම හරි Office eka back to normal තත්වයට එනකොට APP එක හදන්න දුන්නු Company එක closed. ඒකෙ වැඩ කරපු එවුනුත් නෑ

මට ඕනේ හෙල්ප් එක මේකයි... අඩාල web app එක හොස්ටින්ග් කරපු Site එකට මට Access තියනවා. මට එ phpMyAdmin ඩේටා බේස් එකත් ඔපෙන් කරන්න පුලුවන්. එත් මම කොහොමද User කෙනෙක්ගෙ Password eka Reset කරන්නෙ අදාල database එක ඔපෙන් කරලා.

ප්ලේසෙ හෙල්ප් මචන්ලා.

DB එක ඔපෙන් කරපුවාම මේවගේ

View attachment 182464

අලුත් user කෙනෙක් හදන්න root privileges deela

 

[roba "chama"]

$2y$10$9lWYLxdJy.R8jgsPjyL8Ruwl4XG

admin123

 

[Jack_Sparrow]

DB eka awit oyage app ekene
ara uda kiwwa wage aluth password eka hash karala eka DB eke dammot weda karanawa
habai app eke mokadda use karana hashing algorithm eka danaganna oni (md5, sha256 etc)
eka dannawanam aluth user kenek dannat puluwan

 

[LajjaNathiBayya]

$2y$10$9lWYLxdJy.R8jgsPjyL8Ruwl4XG

admin123

Incorrect email or password kiyala enawane

---

DB eka awit oyage app ekene
ara uda kiwwa wage aluth password eka hash karala eka DB eke dammot weda karanawa
habai app eke mokadda use karana hashing algorithm eka danaganna oni (md5, sha256 etc)
eka dannawanam aluth user kenek dannat puluwan

hashing algorithm eka danaganna oni (md5, sha256 etc)

meka kohomada hoya ganne
------ Post added on Aug 23, 2022 at 3:31 PM

---

aluth account ekak hadapan oni password eka dala. ita pase eke hash eka okata dala aluth eka del kapan.

eth Incorrect email or password kiyala enawane bro
------ Post added on Aug 23, 2022 at 3:35 PM

---

meka thama password filed eka
------ Post added on Aug 23, 2022 at 3:38 PM

 

[Anonymous_Abstract]

Incorrect email or password kiyala enawane

---

------ Post added on Aug 23, 2022 at 3:38 PM

hash karala danna uba use vena hashing algo eka denaganna ona. backend code eke balapan eka thiyei use karana hasing method eka

 

[isuru_]

aluth account ekak hadapan oni password eka dala. ita pase eke hash eka okata dala aluth eka del kapan.

meka thamai best ma method eka. source code eka thiyanawa nag registration page eke code eka balala passe himita password reset ekak hadaganna

 

[LajjaNathiBayya]

meka thamai best ma method eka. source code eka thiyanawa nag registration page eke code eka balala passe himita password reset ekak hadaganna

me widiyata aluth ekak hadala. hash eka dunna eth Incorrect email or password error eka enawa.
habayi mama aluth eka delete kale na. ekadha hethuwa

 

[snakedoctor]

Incorrect email or password kiyala enawane

---

hashing algorithm eka danaganna oni (md5, sha256 etc)

meka kohomada hoya ganne
------ Post added on Aug 23, 2022 at 3:31 PM

---

eth Incorrect email or password kiyala enawane bro
------ Post added on Aug 23, 2022 at 3:35 PM

---

View attachment 182465

meka thama password filed eka
------ Post added on Aug 23, 2022 at 3:38 PM

bro check the code sector for password hash, the part which convert varchar to hash and save it to the DB, if you have access to the web app hosting file you can do this easy

 

[CustomerSupport]

$2y$10$9lWYLxdJy.R8jgsPjyL8Ruwl4XG

admin123

That's bcrypt ban. Screenshot eke thiyenne md5

 

[kinkon]

බම්ප්

 

[D-ICE]

othana edit kiyala thiyenne..eka click karama password eka danna puluwan.normal text walin gahala save karanna kalin type eka MD5 kiyala dla save karapan...

 

[kavindagk]

oka karanne DB side eken ba ban, umba aluth ekak hadanakota api hithamu (New user registration) enter karanne me wage fields set ekak kiyala

1. user name
2. first name
3. last name
4. email
5. password

kiyana set eka kiyala, ethakota new userta , godak welawata kalin dapu user name and email use karanne bari wenna hadala aththe, e kwwe
umbe user registration form eka wada karanne me wage widiyakata (me example eke godak fields use kalata, godak nowenna puluwan)

HASH(<column combination>,<key>) ---> database table password column
HASH(username and/or email and/or password , current time stamp and/or machine UID)---> database table password column, ethakota Hash walata AES,DES,SHA,SHA256 wage oni ekak use karanne puluwan.

mata pena widiyata oyata thiyenne option 2k,

1. Registration form eke code eka balala eken hash wena widiya hoyala e logic eken password reset karana eka - meka godak amarui , e wagema godak welawata me code eka hoyaganne eka lesi na

2. danata thiyana userge entry eka delete karala, new user kenek widiyata register karana eka (meka thama godak oyea hashing wena registration option thiyana application wala use karanne , e kwwe password reset eke godak welawata wenne exsiting user delete karala new user kenek widiyata add karanawa)

 

[Amith0424]

aluth account ekak hadapan oni password eka dala. ita pase eke hash eka okata dala aluth eka del kapan.

meka karala hari giye naththam password validation check karana thana balanna wenawa. oya hash pwd ekata amatharawa thawa user data check karanawa athi

current pwd: user123 (md5)

meka daala try karala balanna mulin
admin123
0192023a7bbd73250516f069df18b500

 

[හෙළයෙක්]

me widiyata aluth ekak hadala. hash eka dunna eth Incorrect email or password error eka enawa.
habayi mama aluth eka delete kale na. ekadha hethuwa

ehenan salt athi machan email eken wage userge data ekak eka check wenawa athi ehenan

---

Aluth account ekak hadala primary key 2ka change karoth mokada ita pase parana eke username eka __OLD_USERNAME__ wage prfix ekak dala ain karana.
------ Post added on Aug 23, 2022 at 9:48 PM

 

[pasansnoop]

issellama App eke source files access karala register file eka hoyaganna (ex: php walin hadapu ekaknam register.php wage)..
eken balanna password value ekata dapu hashing algorithm eka (SHA256, MD5 wage)..
dan password hash value ekata salt ekak (random value) ekak add karalanam ekath balaganna..
dan aluth password ekak liyala eka online hashing site ekakin ara algorithm ekata convert karaganna (mathaka athuwa salt ekath include karanna ehema ekak dalanam)..
dan aluth hash eka copy paste karanna db eke user ge password field ekata

 

[KandyMalli]

Source code eka balalama kranna wei neh


Hashing+ salt athi