set new admin via SQL phpmyadmin

[samuel.sabandar]

Hi, please help

I lost my admin info

How do you know what is the current admin email?
How do you set a new admin email and password via SQL phpmyadmin command?

thanks


Linkback: https://www.modified-shop.org/forum/index.php?topic=29818.0

[ShopNix]

select customers_email_address from customers where account_type = 0;

Setting a new password by mysql is not so easy, because you have to set a hash instead of a plain password. You will find the coding in /inc/xtc_encrypt_password.inc.php

Try to register as a new customer, set customers.account_type to 0 and all permissions in admin_access to 1 for the new customers customer_id.

[baalze]

Code: SQL  [Auswählen]

UPDATE customers SET customers_email_address = 'newemail', customers_password = MD5('newpassword') WHERE customers_id = 1

where newemail, newpassword are placeholders for the new data.

[jannemann]

Hi samuel,

just take a look into the wiki for resetting the admin passwort:

Adminpasswort rücksetzen per SQL-Befehl

Schöne Grüße,
Jan