Criando um novo usuário via sql no Magento
INSERT INTO admin_user SELECT
NULL `user_id`,
"Firstname" `firstname`,
"Lastname" `lastname`,
"newuser@test.com.br" `email`,
"suporte" `username`,
md5('suporte') `password`,
NOW() `created`,
NULL `modified`,
NULL `logdate`,
0 `lognum`,
0 `reload_acl_flag`,
1 `is_active`,
NULL `extra`,
NULL `rp_token`,
NOW() `rp_token_created_at`
;
INSERT INTO admin_role SELECT
NULL `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` = 'suporte') `user_id`,
'suporte' `role_name`
;