Help! Lost Password, what can I do!?

[edward]

I lost my password and now I can't log in (obviously).

Is there any way I can get it back? I am the admin of the website so I do have access to all the files/ mysql

please help thanks

[tomsommer]

I lost my password and now I can't log in (obviously).

Is there any way I can get it back? I am the admin of the website so I do have access to all the files/ mysql

please help thanks

go to the _authors table in your database and do

UPDATE {prefix}_authors SET password = md5('mynewpass') WHERE id = {authorid}

[edward]

thanks!

[JimBob]

Hi,

I am locked out and my login I have been using for months suddenly won't work. I looked in the database and the username for authorid 1 is "admin" which is not what I set it as. Anyway I run the sql you said and get the following: (I tried as it was posted and kept getting an error near '{prefix}authors untill I changed it)

UPDATE serendipity_prefixauthors SET PASSWORD = md5( 'a3m2i6c8o4m' ) WHERE id = {1}
MySQL said:
#1064 - You have an error in your SQL syntax near '1}' at line 1

I have tried every combination I can logically think to try and nothing works.

What is wrong please?

Thanks in advance for your help.

JimBob

[tomsommer]

UPDATE serendipity_authors SET PASSWORD = md5( 'a3m2i6c8o4m' ) WHERE id = 1