Admin account lost ?

Ghotcom

Hello, I am a newcomer to Vanilla. I managed to set up the application on my host, then i logged in through my web-browser giving the user:Admin password:Admin combination. Once connected i headed to the Account section and had my username and password modified. Next i begun creating categories and discussions, those got stored as expected.. At some point i logged out, and now i cannot log in again, my new admin username and passord being rejected.. I may have mistyped the password, but whatever happened.. how can i gain access to my admin account again ? oh and i can t get it mailed as the mail server doesnt seem to be configured

Ghotcom

No comment, actually i hadn t changed the password but the username only. Whip me lol

Bergamot

Do you have access to the database?

Mark

You're going to need access to the database directly. Once in there, you can run this script to change it back to the default "Admin/Admin" username/password:

(this assumes you're using Vanilla 0.9.2.6)

update LUM_User set Username = 'Admin', Password = md5('Admin') where UserID = 1;