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

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

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


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

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';

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

http://md5encryption.com/

change the varchar to md5

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

may need to "flush privileges" too :2 cents:

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'