E107 change admin password with mysql

From thelinuxwiki

Revision as of 23:12, 26 February 2013 by Nighthawk (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

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

Retrieved from "http://www.thelinuxwiki.com/index.php?title=E107_change_admin_password_with_mysql&oldid=114"

e107