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`;
