Create Admin User in Magento Using Sql Query
insert into admin_user select (select max(user_id) + 1 from admin_user) user_id, 'FIRSTNAME' first_name, 'LASTNAME' last_name, 'TEST@EMAIL.COM' email, 'USERNAME' username, MD5('PASSWORD') password, now() created, NULL modified, NULL logdate, 0 lognum, 0 reload_acl_flag, 1 is_active, (select max(extra) from admin_user where extra is not null) extra, NULL, NULL; insert into admin_role select (select max(role_id) + 1 from admin_role) role_id, (select role_id from admin_role where role_name = 'Administrators') parent_id, 2 tree_level, 0 sort_order, 'U' role_type, (select user_id from admin_user where username = 'USERNAME') user_id, 'USERNAME' role_name
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home