This is the way to reset OpenEMM to its default password "openemm":
mysql -u root [-p if password exists] use openemm update admin_tbl set pwd_hash = 0x9bd796996fcdf40ad3d86025c03f2c9e where
username = "admin"; exit
If you want to set the password to a specific phrase like "secret":
mysql -u root [-p if password exists]
use openemm
select md5("secret"); update admin_tbl set pwd_hash = 0x5ebe2294ecd0e0f08eab7690d2a6ee69 where
username = "admin"; exit
The alphanumeric code which is prefixed by 0x (to tag the following code as hex code) is generated by the preceding select md5() statement.
Visitor Comments
Comment #1 (Posted by Juan Mijares
)
I´ve tried too many times to reset my lost password in OpenEMM following the above advice but it always ends giving Synthasis error 1064 (42000). I would appreciate some help
Comment #2 (Posted by rikardom
)
use config.bat
btw - TY