Anyway to change a MySql password via phpmyadmin? - GoFuckYourself.com

Juicy D. Links · 04-07-2010, 05:08 PM

I know its encrypted when you view it but taking a shot in the dark any way of doing this?

X0X0

-JDL

GrouchyAdmin · 04-07-2010, 05:10 PM

Well, yeah, if you have access to the users table. Duh.

Juicy D. Links · 04-07-2010, 05:12 PM

Quote:

Originally Posted by GrouchyAdmin

Well, yeah, if you have access to the users table. Duh.

Yeah i do for example

user "juicy"

pass "a3fd82430bee5f99dd7ebf2ad07c2baa"

the pass i can just change it for example to "burp" and it will be ok?

thx in advance

Juicy D. Links · 04-07-2010, 05:13 PM

i was always under assumption that in the table for password such as

pass "a3fd82430bee5f99dd7ebf2ad07c2baa" <----som sort of encrypted thingy

Varius · 04-07-2010, 05:15 PM

Hey Juice, long time

It depends what way it's encrypted, usually the two most common ways are going to be MySQL's default password function or md5, in which case you can do either of:

UPDATE table SET password=PASSWORD('newone') WHERE user='juicy';

or

UPDATE table SET password=md5('newone') WHERE user='juicy';

directfiesta · 04-07-2010, 05:15 PM

you need to repace it with an encrypted password ( MD5)

http://md5encryption.com/

Domain Broker · 04-07-2010, 05:16 PM

change the varchar to md5

Juicy D. Links · 04-07-2010, 05:24 PM

Quote:

Originally Posted by Varius

Hey Juice, long time

It depends what way it's encrypted, usually the two most common ways are going to be MySQL's default password function or md5, in which case you can do either of:

UPDATE table SET password=PASSWORD('newone') WHERE user='juicy';

or

UPDATE table SET password=md5('newone') WHERE user='juicy';

Quote:

Originally Posted by directfiesta

you need to repace it with an encrypted password ( MD5)

http://md5encryption.com/

Quote:

Originally Posted by Domain Broker

change the varchar to md5

cool thx everyone I am gonna test it out now I love u alll

woj · 04-07-2010, 05:32 PM

may need to "flush privileges" too

GrouchyAdmin · 04-07-2010, 05:34 PM

then click your ruby slippers three times and repeat 'there's no password like 68b329da9893e34099c7d8ad5cb9c940, there's no password like 68b329da9893e34099c7d8ad5cb9c940, there's no password like 68b329da9893e34099c7d8ad5cb9c940'

04-07-2010, 05:08 PM	#1
Juicy D. Links So Fucking Banned Industry Role: Join Date: Apr 2001 Location: N.Y. -Long Island -- Posts: 122,992	Anyway to change a MySql password via phpmyadmin? I know its encrypted when you view it but taking a shot in the dark any way of doing this? X0X0 -JDL

04-07-2010, 05:10 PM	#2
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	Well, yeah, if you have access to the users table. Duh. __________________ AIM: GrouchyGfy

04-07-2010, 05:15 PM	#5
Varius Confirmed User Industry Role: Join Date: Jun 2004 Location: New York, NY Posts: 6,890	Hey Juice, long time It depends what way it's encrypted, usually the two most common ways are going to be MySQL's default password function or md5, in which case you can do either of: UPDATE table SET password=PASSWORD('newone') WHERE user='juicy'; or UPDATE table SET password=md5('newone') WHERE user='juicy'; __________________ Skype variuscr - Email varius AT gmail

04-07-2010, 05:15 PM	#6
directfiesta Too lazy to set a custom title Industry Role: Join Date: Oct 2002 Location: Punta Cana, DR Posts: 29,585	you need to repace it with an encrypted password ( MD5) http://md5encryption.com/ __________________ I know that Asspimple is stoopid ... As he says, it is a FACT ! But I can't figure out how he can breathe or type , at the same time ....

04-07-2010, 05:32 PM	#9
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	may need to "flush privileges" too __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

04-07-2010, 05:13 PM	#4
Juicy D. Links So Fucking Banned Industry Role: Join Date: Apr 2001 Location: N.Y. -Long Island -- Posts: 122,992	i was always under assumption that in the table for password such as pass "a3fd82430bee5f99dd7ebf2ad07c2baa" <----som sort of encrypted thingy

04-07-2010, 05:16 PM	#7
Domain Broker So Fucking Banned Industry Role: Join Date: Oct 2004 Posts: 2,427	change the varchar to md5

04-07-2010, 05:34 PM	#10
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	then click your ruby slippers three times and repeat 'there's no password like 68b329da9893e34099c7d8ad5cb9c940, there's no password like 68b329da9893e34099c7d8ad5cb9c940, there's no password like 68b329da9893e34099c7d8ad5cb9c940' __________________ AIM: GrouchyGfy