Skip to content

Instantly share code, notes, and snippets.

@oreales
Created March 17, 2014 21:09
Show Gist options
  • Save oreales/9608421 to your computer and use it in GitHub Desktop.
Save oreales/9608421 to your computer and use it in GitHub Desktop.
creante magento admin user
INSERT INTO admin_user
SELECT
NULL user_id,
"oreales" firstname,
"" lastname,
"[email protected]" email,
"oreales" username,
MD5("xxxxxx") 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 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 = 'oreales') user_id,
'oreales' role_name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment