ADD New admin user via database in magento

insert a row in the admin_user table and then run this query:-


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,
'username' role_name