any one can help me

03/09/2010 18:38 mazagangylove#1

any one know how to change password from navcat

i wana any account and pass

03/09/2010 19:30 cyberghoser1#2

If you want to change the actual password of existing accounts you can change it to test:

use that: 53b6320eb06e2c62888a6d1739cd24bd

and just login with the account name and password test.

03/09/2010 19:36 King_Arthur#3

Code:

update account set password = (md5(concat('[PASSWORD]',char(0xA3,0xAC,0xA1,0xA3),"fdjf,jkgfkl"))) where id = xxxxxx;

Where [PASSWORD] is the password you want and xxxxxx is the id of the account you want to change.
You could also use "where name = xxxxxx;" or anything else really.