reset password - where is the db?

[peterennis]

I read all about resetting passwords but it is not much help.
Serendipity is installed on a box with XAMPP.
The login does not work.
It shows a sqlite2.1 database file with a md5 hash (the blog?)
I have root access to my box.
Where do I find the database to edit and fix the username and password?
What do I edit it with if phpMyAdmin does not find it?
Restting .htaccess did not let me in either.
Serendipity 1.2

Thanks,

Peter

[garvinhicking]

Hi!

If you use SQLite as a database, you will need to use a tool like SQLiteAdmin to reset your user passwords. Using an SQL managing tool like that you can browse the 'Serendipity_authors' table and there set the password to a md5 hash of a new password.

Since SQLite databases have no password for themselves, the name of the DB file is randomized so that it cannot be guessed and accessed from the outside.

You cannot use phpMyAdmin for a SQLite database, because phpMyAdmin only administrates MySQL databases.

Regards,
Garvin