Resetting password and user name in control panel

[artwalls]

Hello
I have been locked out of my control panel, so I cant update my site.
I had language issues that have now been sorted via the php SQL thing,,,,,,so Thats all fine !!I think !
I have tried to get into my control panel via all the usual routes, firstly it did not recognise my user name or password, yet I never changed them from the presets, so I went through the "forgot password" routine, then it wouldnt recognise my email, so again went to SQL as directed by An administrator, and done what he told me to do.
The email was then sent to the correct address,,,,,,well according to the message i got telling me so, but it has never arrived, so I changed the email address in the SQL and tried another one, still nothing, so I am at a dead end.
were the hell do I go now to reset the admin password and user name so I can update my site.
Is it a case of doing a back up and deleting the site and starting over, and uploading the back up,,,,,,doesnt sound like a good idea so I hope thats not the case.
CAN SOMEONE please please tell me were to reset this


Thanks

[abolabo]

hello again:)

If you do not receive emails that means you does not set up email preferences of your AbanteCart.
You can do this manually via sql changes. You have to open table your_prefix_"settings" and change values for those keys:
     key name                               value

1. config_mail_protocol            smtp
2. config_mail_host                   ssl://smtp.gmail.com
3. config_smtp_port                   465
4. config_smtp_username       your_user_name@gmail.com
5. config_smtp_password        ********

then go to login page and repeat password recovery procedure.
You have to get email.
If not - i have another way to recovery password but it's harder:)

By the way. Did you saved password into browser's password manager?

[Basara]

hello.

Please do not duplicate topics. I found at least 4 topics with same problem from You.

[artwalls]

hello.

Please do not duplicate topics. I found at least 4 topics with same problem from You.

Sorry I was getting to the desperate stage,,,,and no answers
I will not duplicate any further posts

[artwalls]

hello again:)

If you do not receive emails that means you does not set up email preferences of your AbanteCart.
You can do this manually via sql changes. You have to open table your_prefix_"settings" and change values for those keys:
     key name                               value

1. config_mail_protocol            smtp
2. config_mail_host                   ssl://smtp.gmail.com
3. config_smtp_port                   465
4. config_smtp_username       your_user_name@gmail.com
5. config_smtp_password        ********



then go to login page and repeat password recovery procedure.
You have to get email.
If not - i have another way to recovery password but it's harder:)

By the way. Did you saved password into browser's password manager?

I shall try this, but before I do, When I backed up the site yesterday I received an email to the account telling me that I had backed it up, so surely if that email went to my email address then so should the one for the reset ?
sorry I am a bit confussed

Been into SQL setting, email and only find "store main email" and it is there and correct, cant see were to change smtp, and protocol etc,,,,,,,,,,,,
cant see anything like this

1. config_mail_protocol           
2. config_mail_host                 
3. config_smtp_port                   
4. config_smtp_username     
5. config_smtp_password     

Have it like this

Have all of this ?


setting_id    int(11)          
store_id    int(11)          
group    varchar(32)          
key    varchar(64)          
value    text          ****************
 

[artwalls]

By the way. Did you saved password into browser's password manager?

Yes, never changed them from the originals

[artwalls]

can we try another way Guys,,, I need to get into this

Thanks

[abantecart]

Try this
http://forum.abantecart.com/index.php/topic,547.msg1688.html#msg1688