Customers update password

[spawn69]

Dear all,

 

I'm trying to update all my customers password with a default one. Is it possible to do it from phpmyadmin for all my customers?

[vekia]

you have to generate one new password then copy hash and use this sql query

update ps_customer set passwd = 'hash here'

[Ron morales]

and update customers mysql active?

Edited April 22, 2016 by Ron morales (see edit history)

[Ron morales]

update prstshp_customer set active = 1

WHERE

active = 0;

 

update prstshp_customer set newsletter = 1

WHERE

newsletter = 0;

thanks