Magento add admin user in MySQL

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

8 Comments

• 
  Ayush Sugandhi December 27, 2012 at 11:54 am

  Good one…

  Reply
• 
  Matt Humphrey March 19, 2013 at 4:01 pm

  I have created a tool to generate the SQL for you. http://m4tt.io/tools/magento-admin-generator/

  Reply
  • 
    Фкеуь December 16, 2013 at 12:15 pm

    Good job!

    Reply
• 
  Kathy Daunt June 24, 2013 at 11:22 am

  Is it possible to set global password for admin ?

  Reply
• 
  Pavel Nikolov August 15, 2013 at 9:07 am

  It is a nice idea to use a salt string with the password.

  $salt = ‘h3ud7’;
  $password = ‘some_secret_passworD_here’;
  $password_hash = md5($salt . $password) . ‘:’ . $salt;

  Reply
• 
  sandeep September 21, 2013 at 12:09 pm

  nice its really great help for me

  Reply
• 
  sandeep September 21, 2013 at 12:10 pm

  its really great helps for me

  Reply
• 
  ankit May 30, 2014 at 4:19 am

  great work… i love your snippets ….great work once again

  Reply