Difference between revisions of "E107 change admin password with mysql"

Latest revision as of 23:12, 26 February 2013

select db

 mysql> use database_name;

display user table

 mysql> select * from e107_user;

reset password for user to "changeme"

 mysql> UPDATE e107_user SET user_password='4cb9c8a8048fd02294477fcb1a41191a' WHERE user_loginname='adminusername';
 Query OK, 1 row affected (0.00 sec)
 Rows matched: 1  Changed: 1  Warnings: 0