## Update a lost Admin password for a user UPDATE admin_user SET password=CONCAT(MD5('SALTpassword'), ':SALT') WHERE username='admin'; ## Create a new Admin user in the database http://m4tt.io/tools/magento-admin-generator/ INSERT INTO admin_user SELECT NULL `user_id`, "$firstname" `firstname`, "$lastname" `lastname`, "$emailaddr" `email`, "$username" `username`, "MD5($password)" `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` = "$username") `user_id`, 'admin' `role_name`;