Simple SQL Query

[Stiganator]

Ok I'm trying to change the admin password for my wiki, but it won't run the query and I don't know why.

Database wikidb
table wiki_user

Query
---------
use wikidb;
update wiki_user set user_password=md5(concat('1-',md5('password'))) where user_id=1;
------

It doesn't work though, what am I doing wrong

 

[troytime]

are you md5ing the word "password"?

also, don't md5 an md5, it makes the hash weaker

 

[troytime]

btw, your query looks fine, other than the double md5 and the md5ing the word 'password'

i even created a table with that name and that column and tested it (in mysql)

 

[KLin]

Why are you concatenating '1-' to the md5 result of the value 'password'? Just curious.