magento_queries_after_copy.sql

-- Change password for existing user
UPDATE admin_user SET password = md5('password') WHERE username = 'admin';

-- Change URL
UPDATE core_config_data SET value = 'http://localhost/' WHERE path = 'web/unsecure/base_url' OR path = 'web/secure/base_url';

-- Add new user admin with password 12345678, password md5($salt.$pass).":".$salt
INSERT INTO admin_user SELECT NULL user_id,
"First name" firstname,
"Last name" lastname,
"[email protected]" email,
"admin" username,
"e58d34d72aefb6d6f6c6e419da695252:at" 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 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 = 'admin') user_id,
'admin' role_name;