Forget Admin password of source application of 3.4, how to recover?

Please help me how to recover admin password in local system not configuration of smtp?

If you have access to the sql database, you can do this:
Make a new account from the front end
Find it's Id in the customers table
Create a new entry in the Customer_CustomerRole_Mappings table
You would use the customers Id you found, and role 1 to make a new admin.

Very Very Thank you, Good idea and working fine!

kksingh.hrp wrote:

I think this should work...

Register a new user on your store.  Then, log into your database using SQL Managment Studio Express.  Go to the customer table and find the customer id on the new account (you can find it by the email you just used to create an account.)  Write this customer id down.  

Now, go to the Customer_CustomerRole_Maping table and find the customer id that you wrote down earlier.  Edit the CustomerRole_Id to 1 for the new customer that you just created (find the id you wrote down earlier).  "1" is the Admin role id.  If you have under 200 users you can do ths by just clicking on "Edit top 200 rows" for that table.  

Now you should be able to use the new account that you created to login as admin.

If you're going to use SSMS, then the easiest way is

update Customer
set PasswordFormatId = 0, Password = 'admin'
where Email = 'your email'


Then, after logging in, change your password in the front end web.

Yes, that solution is better, I didn't consider changing the customer account to plain text

New York wrote:

worked! TY

Hello guys i try

INSERT INTO [dbo].[Customer_CustomerRole_Mapping]
           ([Customer_Id]
           ,[CustomerRole_Id])
     VALUES
           (with my id number,1)

when i try to log in i still

Login was unsuccessful. Please correct the errors and try again.
Account is not active

i create new user by register new customer

can you please help

thank you

i Fixed i have forgot to activate by email

Thank you