Today we wanted to change the password of the admin of our Magento store and used the following command, which e.g.. is entered in the phpMyAdmin SQL, after you select the database:
UPDATE `admin_user` SET `password` = MD5('123456') WHERE `username` = 'admin';
“admin-user” here refers to the table in which the users are registered. This is, by default, as indicated. But is a prefix used, must be adapted according to the name of the table.
“123456” is the new password, to be used. Here you can choose any passwords.
“admin” Thus, the username is the name with which you want to log in the backend. If another user is changed, must be even “admin” be replaced by the user name in question.
It is important to pay attention to the correct characters!
Used in Magento versions 1.4.1.1 bus 1.7.0.2.. Ask, Comments, Suggestions? Gladly!
Jup, goes well with it. But going by the way also with n98-magerun, when employing eh 🙂