forget it ! --> md5 cannot be "decoded" back to clear text ;-P you have s test elgg install ? just delete database and reinstall for new admin id & passwd ;-)

You can access the database and change the password and salt fields for your username. Use MySQL's md5 function to generate the password and keep the salt blank.

The query will look something like (DON'T run this without checking your server):

UPDATE elgg_users_entity SET password = MD5('your_new_password'), salt = '' WHERE user = 'your_username' limit 1;

Hello, 

I would lik eto create a new user as admin, ( my table elgg_user_entities is empty)

but i dont know how? I need to create it from my site? or just in databases ?

I tried both of them, but I cant login, 

Do I have to reinstall databases?

help please

help please

Are u able to create a new user ???

I dont have any user in my table elgg_users_entity, so I want to create an admin for it 

@senfour19 - You need to run the installation. Read the README file or check out http://docs.elgg.org/ Also, in the future please create a new topic for unrelated issues.

@Brett, ok thanks 

@Brett So I need to reinstall elgg? start from the beguning thne?

K Start from first one more time..

1)reg one new user 

2)come to back end directly go to metadata table there u can see 4 newly entered user detailz

for example-->

3)delete the second row completly

4) Make 1st row enabled as yes

5)change the 3rd row vale 53 to 4  chane owner_id 0 to new guid (in this eg guid is 51)

6)change 4th row also set owner id value( in my case 0 to 51)

After editing table like this:

 7)go to entities table set guid 51(in my case) enable yes

 8)go to user_entity table set guid 51 as admin

@senfour19 - If you don't have any entries in the user table at all that means you didn't create the initial admin user during installation.