E107 change admin password with mysql

From thelinuxwiki

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