重置magento后台用户密码

最新推荐文章于 2020-12-25 02:15:07 发布

emily_init

最新推荐文章于 2020-12-25 02:15:07 发布

阅读量4.5k

点赞数

进入相应数据库以后,运行select * from admin_user;查看所有后台用户信息.

update admin_user set password=CONCAT(MD5('qXpassword),':qX') where username='admin'; //执行完这条语句即可用admin/password登录后台. 也可以把sql语句里的password换成你需要的密码

Resetting Admin Password

Last modified by naitsirch on Fri, June 24, 2011 04:38

Source | Old Revisions

It seems like the password must be typed and not copy/paste at least on the install part. good to know ;o)

The default login is : admin The default password is : 123123

If you are having troubles and want to reset it to a different password, just run at your sql database:

 
       SELECT *  
       FROM admin_user;

Then, find the username you want to modify in the listing provided - ‘admin’ in this example. Then, to update the password, type:

 
     
       UPDATE admin_user  
       SET password=CONCAT 
       (MD5 
       ( 
       'qXpassword' 
       ),  
       ':qX' 
       )  
       WHERE username= 
       'admin'; 
      
 
   

‘qX’ would be changed to whatever you want it to be and same goes for ‘password’

You can also do this in phpMyAdmin, find the admin_user field and choose MD5 when updating password.

If you want to add a new admin user, you must not only create a new entry in the table ‘admin_user’, but you also have to insert an entry in the table ‘admin_role’ which has to be associated with the user by the field ‘user_id’.

文章转自: http://www.magentocommerce.com/wiki/recover/resetting-admin-password