Create admin using database in magento

Create admin using database in magento

Paste below code into your database and then Login to your Magento admin panel using new credentials.


INSERT INTO `admin_user` (
`user_id` ,
`firstname` ,
`lastname` ,
`email` ,
`username` ,
`password` ,
`created` ,
`modified` ,
`logdate` ,
`lognum` ,
`reload_acl_flag` ,
`is_active` ,
`extra` ,
`rp_token` ,
`rp_token_created_at`
)
VALUES (
NULL , 'chandresh', 'rana', 'chand.4rana@gmail.com', 'chandresh', MD5( 'pass#123' ) ,
CURRENT_TIMESTAMP , NULL , NULL , '0', '0', '1', NULL , NULL , NULL
)



INSERT INTO admin_role SELECT
NULL `role_id`,
0 `parent_id`,
2 `tree_level`,
0 `sort_order`,
'U' `role_type`,
(SELECT `user_id` FROM admin_user WHERE `username` = 'chandresh') `user_id`,
'Administrators' `role_name`;